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
|
