How do I set up an InputBox function in MS Access

[Guest]

I am working to set up a Purchasing Order database and have not been able to
get the inout box funtion working to record user's input, or enter values
that will be used by more then one query.

 

[Rick B]

Not sure what you mean. What is the "inbox function"?

 

[Rick B]

Sorry looks like you meant input, but typed inout.

You would have to tell us what your query is and what parameter you are
asking the user for.

Typically, you would simply put criteria in your query like...

=[enter client number]

or

like "*" & [enter partial name] & "*"

 

[John Vinson]

I am working to set up a Purchasing Order database and have not been able to
get the inout box funtion working to record user's input, or enter values
that will be used by more then one query.

Rather than a Visual Basic InputBox function, consider using an Access
Form. Create a small unbound form (let's call it frmCrit) with
controls - textboxes, combo boxes, checkboxes as appropriate - into
which the user can enter criteria.

Your Queries can then reference

=[Forms]![frmCrit]![controlname]

on the criteria line. You can base a Form (for onscreen display) or
Report (for printing) on this query, and put a command button onto
frmCrit to launch the form or report; there's no need to open the
query datasheet at all if you do so.

John W. Vinson[MVP]