Filter records on form open

E

EdS

Hello.. I have a form that is bound to a table which includes a field called
"status". When the form opens, I would like to display only those records
with an "active" status. Will someone be kind enough to help me with the
coding?
 
K

Klatuu

Use the forms Filter property to include only those records where the status
is active.
 
E

EdS

One more question.. I have added some buttons on the form to toggle the
filter on/off for temporary viewing of the "closed" status records. This
works, however, when I toggle the filter on, it jumps back to the first
record. Might there be some code that I could apply to stay on the current
record when toggling the filter?
 
Top