Input control for a select query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stoney59 - 21 Mar 2006 17:06 GMT

I have a rather simple database that I've designed a switchboard that
runs several macros for producing a report that is based on a select
query. I need to design an input control that assigns a value to a
criteria on which the query/report is based.
TIA for your help.

Reply to this Message

jahoobob - 21 Mar 2006 20:26 GMT

If it is a variable, you can do this in the query in the Criteria for the
field.
If it is a constant, you can place this in the Where Condition field of the
Open Report in the macro.

>I have a rather simple database that I've designed a switchboard that
>runs several macros for producing a report that is based on a select
>query. I need to design an input control that assigns a value to a
>criteria on which the query/report is based.
>TIA for your help.

Reply to this Message