Restricting data displayed in a subform

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I have 3 command buttons on a main form that I want to
use to filter records in a subform. Any suggestions???
 
Create three queries to filter the records the way you want. Then enter the
following code in the Click event of your commandbuttons:
Me!NameOfSubformComtrol.Form.RecordSource = "NameOfQueryFilter"

Note: The double quotes are required.
 
Back
Top