Updating subforms with values from parameter query

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

In Access 2002 I have a form with a text box for entry of
a parameter value and two subforms that have their
recordsource set to queries with the parameter from the
main form. How do I get the query values to display on the
subforms?

Thanks in advance for any assistance.

Jim
 
Hi Jim,

You could try this:
use a textbox on the subforms that reference the textbox
on you parent form. Meaning:

Assuming that u have a textbox called [myparameter] in
your parent form called [frmParent], on your subform you
could use a textbox with the following

controlsource = forms!frmParent!myparameter

That should do it!
 
Back
Top