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.
 

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

Populate main form from subform record 0
DLookup in Continuous form 0
main form/subform 1
Recordset.Clone Help Needed 9
VBA code returns no records hwenKey ID is added 14
Filtered view of Visio Chart 0
Restrict subform from accepting new records 1
subform based on external SQL won't requery 1

Top