Filter records on form open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
Back
Top