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?
 
Use the forms Filter property to include only those records where the status
is active.
 
Appreciate that very much!
--
Thanks. EdS


Klatuu said:
Use the forms Filter property to include only those records where the status
is active.
Click to expand...
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering a Form 3
Need combo box to refresh when moving to new record 2017 1
Filter unbound search combo box based on filter in form's OnOpenEvent 3
Query design 0
Can't edit record - Form is read-only 1
Count number of rcd on continuous form. 3
Coding 3
Access 2007: Help filtering a report query based on a form field 0

Back
Top