B
BillD
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
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