Use query with parameters as datasource for subform

  • Thread starter Thread starter julius.fuchs
  • Start date Start date
J

julius.fuchs

Hi

I have a subform which gets its data from a query. This query uses
parameters I want to be able to modify via textboxes on the main form.
The user should enter some values and then press a button which
updates the subform.
How can I do that?

Thx in advance
 
Hi

I have a subform which gets its data from a query. This query uses
parameters I want to be able to modify via textboxes on the main form.
The user should enter some values and then press a button which
updates the subform.
How can I do that?

Thx in advance
Click to expand...

Your paramters should reference the form directly:

=[Forms]![YourFormName]![YourTextboxName]

Alternatively, you could use the name of the textbox (or textboxes, separated
by semicolons) as the Master Link Field property of the subform, and the
corresponding fields in the subform's recordsource as the Child Link Fields.
 
Back
Top