Check the code where the form is opened.
If it has a Where Clause in the OpenForm, that becomes the form's filter
property.
--
Dave Hargis, Microsoft Access MVP
"BillD" wrote:
> I opened the form in design and the form properties does not show
anything in
> filter anymore (I deleted that). In Advance Filter there is no Field
entry or
> Criteria.
>
> I deleted all of the control buttons and the code that went with it.
When
> looking in the VBA for my fmsContacts there is no code for the form
>
> I saved and closed the form and database. When I open it back up and
then
> open the form all the fields are empty, once I click on "Form Filter"
then
> click "Apply Form" the first entry in the database appears.
>
> I don't know where else to look it is not in the form properties,
Advance
> Filter, or the VBA module
>
> Any Ideas where it could be or am I stuck just having to live with
running
> the filter everytime I open the form.
> --
> BillD
>
>
> "Klatuu" wrote:
>
> > 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
|
