Problem Removing Form Filter

B

BillD

If anyone can help please explain this in simple terms and where I have to
look I am not that good at codes and programming yet

I have a form that is set up in a tab control with 4 tabs (contacts,
registration, registration payement, contributions) I have populated the data
base with only 2 entries so far.
When I open the form all the fields are empty and none of the command
buttons work. Once I go to records and select remove filter the first record
in the table contacts appears in the form and all the command buttons work.

When I go to Records - Filter - Advance Filter/Sort the field shows LastName
and the criteria shows Is Null AND Is Null
When I go to the form in design view the filter shows
(((tblcontacts.LastName Is Null))) AND ((tblcontacts.LastName Is Null))

I have tried to remove the form filter by deleting it and saving the form
and I followed the instructions in help to remove the record in Advance
filter/sort by highlighting and selecting clear grid. However when I close
the form and then reopen it the filters are back and they are populated
automatically.
I have no idea where to look to remove this.
Please help
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Filter will not delete 5
Optionbutton Not working 3
Dates In Excel 5
I figured out the issue thank you. 0
How do I clear a form? 0
Add additional information to excel form after original data entry 0
Access form continuous 1
Clearing combo boxes and a text box 2

Top