Parameter query as subform's RecordSource

  • Thread starter Thread starter Albert
  • Start date Start date
A

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
 
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.
 
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)
 
Back
Top