InputBox within a query

S

sue

I have multi records and I want a query where an input box asks for one
column record.
Column 1 Column 2 Column 3
data place port
day plant box

I want an input box for Column 1 so if I type day into the box all the data
from Column 2 and Column 3 and Column 1 display in a query for me to use in a
report and/or form
 
G

ghetto_banjo

In the criteria for Column1, just type something like:

[Please Enter Parameter Value]


and the query will prompt for the criteria for Column1 and will only
return records that match what the user typed in.
 
R

Richard

You want a textbox on a form, then have the information in the textbox passed
to a query?

Richard




sue said:
But i want to enter the parameter value into a box not the criteria area?

ghetto_banjo said:
In the criteria for Column1, just type something like:

[Please Enter Parameter Value]


and the query will prompt for the criteria for Column1 and will only
return records that match what the user typed in.
.
 
J

John W. Vinson

But i want to enter the parameter value into a box not the criteria area?

Try doing what ghetto_banjo suggested.

If you put the exact text

[Please enter parameter value]

on the criteria line of a query, and base a Report on that query, when the
user opens the report a box will pop up on their screen saying

Please enter parameter value

The report will then take whatever the user types as if it had been typed in
the Criteria line of the query grid. The user never even needs to see the
query grid.

The text in square brackets can be whatever you wish - something that will be
meaningful for the user.
 

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

Top