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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

variables for query criteria 3
Multiple Parameter Crosstab query filter by form 1
Query Criteria Not Working 2
Titles on InputBox within Query 1
passing range values into query criteria problems... 1
One query for report and Excel 3
Use In() Expression as Query criteria with guts from Function 1
Parameter Query for a Text Field 4

Back
Top