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
|
