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
|
