View Full Version : Automatic filter on my form?


Jeff
03-21-2000, 08:13 PM
Hi All,
I have a form based on data from a table. When I open the form, a get a blank (new) record displayed and the record navigator indicates that this is the only record in the table (and I know it's not). The word "Filtered" is NOT displayed.

If I then right-click and choose delete filter, my record navigator suddenly indicates the correct number of records in the table and I can browse through the data as expected.

Question: Why aren't the records showing up when I first open the form? (The form itself does not have a "Filter By:" properties arguement, and there is no VBA code that filters the form) Is there some other place to look where the form may have a filter placed on it?

All I'm looking for here is that when the form is opened, the navigator buttons indicate how many records are in the table and I can browse through the records without having to do the right-click "Remove Filter" manuever.

Thanks for any thoughts,
Jeff

luhlik
03-22-2000, 12:58 PM
Jeff-
Check and make sure you don't have the Data Entry property of the form set to Yes.
Leigh

Jeff
03-22-2000, 07:32 PM
Thanks Leigh!
You are exactly right. It works perfectly now.
Thanks,
Jeff