While I was waiting for your response I tried deleting the Filter entry and
then closed and reopened the data base and I still did not show any
records
when I opened the form, and your right once I applied the filter the first
record opened I was wrong.
So even with the filter expression removed I still have to click on apply
filter in the tool bar to get the first record to show up or to get the
control buttons to work. without filter applied when I click the control
buttons firs or last record nothing happens.
Can you please tell me how I could solve this problem I am not that much
of
an expert on the inner workings of Access. Even if I can get the filter to
stay on all the time that would be acceptable.
--
BillD
"Klatuu" wrote:
> This is the problem:
> Filter: ((tblcontacts.LastName is null))
>
> If a blank form is opening, there are no records that meet the filter
> criteria.
> Also, the normal behavior is for the first record in a form's recordset
to
> be displayed when opened, not the last.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "BillD" wrote:
>
> > I checked the properties for the form and Data Entry = No
> > Here are my Properties as listed
> > Record Source: tblContacts
> > Filter: ((tblcontacts.LastName is null))
> > Order By: Blank
> > Allow Filters: Yes
> > Allow Edits: Yes
> > Allow Deletions: Yes
> > Allow Additions: Yes
> > Data Entry: No
> > Record Type: Dynaset
> > Record Locks: No Locks
> > Fetch Defaults: Yes
> >
> > Any other thoughts
> > --
> > BillD
> >
> >
> > "Klatuu" wrote:
> >
> > > Check the properties for the form. It sounds like the Data Entry
property is
> > > set to Yes. Data Entry forms will not show any existing records.
> > > --
> > > Dave Hargis, Microsoft Access MVP
> > >
> > >
> > > "BillD" wrote:
> > >
> > > > In my database I have 4 forms in a tab control (Contacts,
Registration,
> > > > Payment, contribution). When I open the form contacts in past
databases the
> > > > last entry in the form would appear. In this database all fields
in the form
> > > > are blank. I have several control buttons in the form. If I click
on "First
> > > > Record" or "Last Record" nothing happens, if I click on "Previous
Record" I
> > > > get a message that I can not go to that record. I know the fields
are
> > > > populated as I have checked the tables to verify that.
> > > > I looked into a filter and when I went to Records on the tool bar
then
> > > > opened Advance Filter/sort there is one filter there. It has the
following -
> > > > Field: Inactive Contact, and Criteria: 0 and 0 and 0. In the help
section it
> > > > read to clear the filter open Advance and click on "Clear Grid". I
did this
> > > > and when I closed and reopened the database the filter was back.
> > > > I am trying to find out how to remove the filter or have the
filter on all
> > > > the time. When I open the form and click on Filter by Form than
everything
> > > > works right. I open the form and the last record entered is
visible and the
> > > > control buttons work.
> > > >
> > > > The only thing I can think of that is different from my other
databases is
> > > > that I have two check boxes in the form "inactive Contact" and
"contribution
> > > > only". I have the tab order set up so that the two check boxes are
at the
> > > > begining of the tab sequence Could this have anything to do witht
the filter
> > > > reappearing after I delete it and needing to be turned on. My
other two
> > > > databases I don't have a check box in one and the other has a
check box but
> > > > at the end of the form and I don't have a filter problem.
> > > >
> > > > Please advise again I want to remove the filter permanitly or have
it set to
> > > > be on all the time. Should I try rearainging the tab order so the
check box
> > > > is at the end.
> > > >
> > > > Thanks for the help
> > > >
> > > > --
> > > > BillD
|
