Restricting data displayed in a subform

K

Ken

I have 3 command buttons on a main form that I want to
use to filter records in a subform. Any suggestions???
 
P

PC Datasheet

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.
 
Top