Apply Filter shows all records when in Data Entry Mode...

[MeisoT]

I have a form with its property settings set to allow additions, deletions, and edits. The Data Entry property is also set to true because I want the user to see a blank form with no existing records when the form opens. When the form is opened, the data mode argument is left out so that the form's property settings are used.

There is no criteria set in the form's query.

It works as expected when the form is opened (shows no records), however, if the user clicks the "Apply Filter" or "Remove Filter" button, all the records in the underlying recordset are displayed. I would like the filter buttons to show only newly added records since the form has been opened, not any of the previous existing records.

What am I doing wrong? Or is this the normal behavior of Access?

Any input is appreciated.

 

[Eupher]

Hi, MeisoT,

I believe this is normal Access behavior. I think to get around this you will need to disable menus and button bars in the DB startup options, then build your own custom menus - that is, if you need menubar functionality. It's possible to construct a database where user interaction is controlled entirely by the switchboard and forms.

Ken S.

 

[MeisoT]

Thanks Eupher,

I already have a custom toolbar set up so I guess I will have to disable the filter buttons or set some type of criteria to limit the records before the filter is applied.