Filter by option group

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

I have a form that I would like to filter by the status on the form. There
statuses on the combo box are open inprocess accounting and closed. I would
like to have an option box which the user would filter on the option
selected and then only those records would appear.
 
On Tue, 7 Oct 2008 20:01:01 -0700, Rpettis31

Filtering is done by setting the Form_Filter property to some Where
clause (e.g. Where StatusID=1), and then the FilterOn property to
True.
You would write your code in the <groupbox>_AfterUpdate event.

-Tom.
Microsoft Access MVP
 
Back
Top