One last thing than I noticed that now when I open up the Advance filter
now
the field is "LastName" and the Criteria reads "Is Null and Is Null"
I did not enter that the program entered it on it's own I don't know if
that
means anything if it does not then I will just have to click on the
"Remove
Filter" each time I open the form
Thanks for you time
--
BillD
"Klatuu" wrote:
> Those are properties for the switchboard form, not anything the
swithcboard
> form would be opening. I really don't know where else to look.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "BillD" wrote:
>
> > The form opens through my switchboard. When I looked at the properties
for
> > the switchboard in design view I saw the following:
> > Filter: [ItemNumber]=0 AND [Argument]= 'Default'
> > Data Entry: No
> >
> > Could this be the problem and if it is what should I do
> > --
> > BillD
> >
> >
> > "Klatuu" wrote:
> >
> > > 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
|
