Send query value in macro

[samuel]

Using access 2003.

I have a query with a criteria [Which facility?] at run time, the user can
type in the value they want.

Is it possible to supply the value in a macro, so the query could execute
without user input. I understand I could build 3 different queries with the
value hard-coded, but I'm thinking the macro would be a bit easier.

 

[Steve Schapel]

Samuel,

No a macro is not applicable in this situation.

It is not clear what you mean by "the query could execute without user
input". If the query requires a criterion, it has to be supplied from
*somewhere*. Where is it going to come from, if the user doesn't supply or
indicate it?

However, if there was a textbox (or combobox or other suitable control) on a
form, where the user could enter the criterion, then the [Which facility?]
in the query could be replaced by a reference to the textbox, using syntax
such as:
[Forms]![NameOfForm]![NameOfControl]