Filtering a Form (PLEASE HELP ASAP) Project due on short timeline

J

JC

I have a table with two yes/no fields. I am creating a form to audit
individual records but do not want records that have already been reviewed to
show. I have tried multiple ways to filter the form by selecting the
properties option for the form and entering include=yes or include=-1, and so
forth. It is not filtering. I know it is something simple, but just can't
figure out what I am doing wrong. I will need to have the filter on two
fields so please respond with how to do that as well. I am not a big coding
guru so please keep it simple and preferrably out of VB code.

Please help!
 
G

George Nicholson

In the Open event of your form you might add the following:
Me.FilterOn = True
and see if that helps.

Alternatively (and no code required), set the recordsource of your form to a
stored query based on a table, not the table itself. Set the appropriate
filtering criteria for [Include] (and any other fields) in the query and you
won't have to worry about filtering the form. *When you can* it is always
better to filter the data before it gets to the form/report than filter the
form/report itself.

HTH,
 
J

John Vinson

I have a table with two yes/no fields. I am creating a form to audit
individual records but do not want records that have already been reviewed to
show. I have tried multiple ways to filter the form by selecting the
properties option for the form and entering include=yes or include=-1, and so
forth. It is not filtering. I know it is something simple, but just can't
figure out what I am doing wrong. I will need to have the filter on two
fields so please respond with how to do that as well. I am not a big coding
guru so please keep it simple and preferrably out of VB code.

Please help!
Click to expand...

Simply base the Form - not on your Table - but on a Query with a
criterion on the field.

Alternatively, if you use the Form's Filter property, make it

[Include] = True

or

[Include] = -1

and set the Form's FilterOn property to True.

John W. Vinson[MVP]
 
Top