Setting parameter in a subform

acotgreave

New member
Local time
Today, 17:36
Joined
May 18, 2005
Messages
7
Hi,
This is my first post...

Anyway, I have a form, frmTest, with a subform, frmTestResults.

The subform displays the results of a query which has a single parameter, "TestID".

Using VBA, I want to open frmTest in response to a button press on another form, using DoCmd.OpenForm, and setting the OpenArgs property to the TestID I want to display.

In the VBA, how do I set the parameter value of the subform so that it automatically runs the query and displays the correct results?

Thanks,
Andy
 

Users who are viewing this thread

Back
Top Bottom