Message box for query filter

  • Thread starter Thread starter Bryan
  • Start date Start date
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.
 
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.
 
Back
Top