Filter Subform

S

Seba

Hello,

I have a form "Contractor" and a Subform "Budget", I would like to filter the
main form based on a programBudget which is a field in the subform. I know I
can set this by using the "on Open" property of the form, but I don't know
how to go about doing this. I only want three of the ProgramBudget to
display with their corresponding Contractor. Is there a way to this via
macro or any other form. Any help would be great. Thanks.
 

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

Conditional Formatting on Subform 3
Pass Subform filter to subform in report 0
Error 2465 getting recordset for subform 5
Filter main form to records with no related records in subform,maintain updateable recordset 4
Access Daily Entry with multiple entries per field 0
Filter pivotchart in report 1
Command button filter on a subform 2
filtering main form via selecting record in subform 5

Top