Input Box from QRY

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

Hello,

I have a button on my form that runs a QRY, but the QRY has a input need to
run it.
How would I go about inputting the value in SPK in the input box that pops
up to run the QRY. Thanks in advance.

Aaron
 
Hello,

I have a button on my form that runs a QRY, but the QRY has a input need to
run it.
How would I go about inputting the value in SPK in the input box that pops
up to run the QRY. Thanks in advance.

Aaron
Click to expand...

You've asked a very generalized question.
In general, anytime you place brackets around something that Access
doesn't recognize as a field it will prompt for the value, i.e.
Who:[Enter the name]

If the above doesn't help, how about a more specific question so the
answer you get is relevant to you and not to some other hypothetical
query.
 
Hello,

I have a button on my form that runs a QRY, but the QRY has a input need to
run it.
How would I go about inputting the value in SPK in the input box that pops
up to run the QRY. Thanks in advance.

Aaron
Click to expand...

Rather than using a popup prompt such as

[Enter SPK:]

consider using an unbound textbox on your form - txtSPK perhaps - and a
criterion

=Forms![NameOfYourForm]![txtSPK]
 
Back
Top