Accessing subforms with macros in Access

G

Guest

I've created a form in an Access 2003 database, and within that form I have a
subform that displays a table of data. I want to have buttons on the form
that filter the data on the subform in different ways. I can select an entry
in the subform and use the "Filter by Selection" button to filter the data,
but I can't do the same action using a macro (which would be activated by one
of the buttons). The problem seems to be accessing the subform from the
macro. Can anyone help or suggest an alternative way of doing this?
 
S

Sue Mosher [MVP-Outlook]

Try asking in an Access group. This forum is for Outlook issues.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 

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

Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Access Reference Subform's Control 0
How do I filter data on a subform using a macro? 0
Refreshing filter on Subform in Access 2010 0
Access Access Report Works on One Machine but not Another 3
Run Query on Subform Using VBA Macro Button 1
Access Daily Entry with multiple entries per field 0
Subform Data Entry Setting 0

Top