Where is the filter set? If it is just in the properties dialog. just
deleting it and closing the database will not do it. You need to open the
form in design view, delete the value from the dialog and save the form.
If
it comes back it means the filteris being set by code somewhere. You need
to
track that down and fix it.
--
Dave Hargis, Microsoft Access MVP
"BillD" wrote:
> 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
|
