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