Message box for query filter

B

Bryan

In the "criteria" field of a query, can use the InputBox
function or the like to request the parameter from the
user? If so, how? I've tried InputBox("enter job ID")
and it didn't work.
 
K

Ken Snell

No, you can't use InputBox.

Instead, just put the text of the message inside [ ] such as this:

Like [Enter the text string:]

When the query runs, a parameter box will be displayed showing the message
"Enter the text string:" and a textbox for the user to type the string.
 
Top