Use query with parameters as datasource for subform

[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

 

[John W. Vinson]

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

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.

 

[julius.fuchs]

Your paramters should reference the form directly:

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

Thx a lot for your effort, it works!