Parameter query as subform's RecordSource

[Albert]

Hello,

Is it possible to use Parameter query to be a subform's RecordSource. And
when form is opened, Have anyway to assign thoses parameters. I don't want
Input Parameter Dialog Box display to ask user to input value.

Regards,
Albert

 

[Van T. Dinh]

It is possible.

For example, you can have Form1 open which has a Control that user can enter
the value for the Parameter and a CommandButton to open Form2 which has the
Subform whose RecordSource is a Parameter Query with the Parameter being the
Control on Form1 mentioned above.

 

[david epsom dot com dot au]

Access queries can see forms, VBA, User Defined functions, and tables.

You may put your parameters into a Form, User Defined function,
or table.

to refer to a form: Forms!frmName!ControlName.
to refer to a UserDefined function: gfnName() or gfnName([field],....)
to refer to VBA: Date,Now,Environ,Command, etc


(david)