Filtering on a Form set to Data Entry Mode = Yes

  • Thread starter Thread starter chris1 via AccessMonster.com
  • Start date Start date
C

chris1 via AccessMonster.com

I have created a form that has the Data Entry property set to 'Yes' with the
following other properties set to 'Yes' as well: Allow Filters, Allow Edits,
Allow Deletions and Allow Additions

The user only sees a a blank record when they open the form however I have an
option button that allows the user to filter their prior inputs for editing.
When the filter is turned off however all the records of the table are
displayed.

How do I prevent all the records from being displayed when the filter is
turned off. It works well when the form is for new information. My form is
bound to a table with the filter using an unbound textbox as the
wherecondition in the DoCmd.ApplyFiler statement.

I guess one way would to set the Allow Filters to No and use VBA code for
filtering. Does that sound right?
 
chris1 said:
I have created a form that has the Data Entry property set to 'Yes'
with the following other properties set to 'Yes' as well: Allow
Filters, Allow Edits, Allow Deletions and Allow Additions

The user only sees a a blank record when they open the form however I
have an option button that allows the user to filter their prior
inputs for editing. When the filter is turned off however all the
records of the table are displayed.

How do I prevent all the records from being displayed when the filter
is turned off. It works well when the form is for new information.
My form is bound to a table with the filter using an unbound textbox
as the wherecondition in the DoCmd.ApplyFiler statement.

I guess one way would to set the Allow Filters to No and use VBA code
for filtering. Does that sound right?
Click to expand...

DataEntry = Yes is nothing more than a filter that filters out everything so
when you "remove filters" you will see all records. Instead of turning the
filter off just set the DatEntry property to True again and all records
should disappear.
 
Rick,

I feel foolish. That is brilliant and easy to implement. Thank you for your
time!

Rick said:
I have created a form that has the Data Entry property set to 'Yes'
with the following other properties set to 'Yes' as well: Allow
Click to expand...
[quoted text clipped - 12 lines]
I guess one way would to set the Allow Filters to No and use VBA code
for filtering. Does that sound right?
Click to expand...

DataEntry = Yes is nothing more than a filter that filters out everything so
when you "remove filters" you will see all records. Instead of turning the
filter off just set the DatEntry property to True again and all records
should disappear.
Click to expand...
 
Back
Top