Forms asking for input

[Lana]

I have a query that asks for input. It works, but when it put into a form
with a subform it asks for the input value 3 times. What did I do wrong? How
can I make it ask for the input only once?

 

[John W. Vinson]

I have a query that asks for input. It works, but when it put into a form
with a subform it asks for the input value 3 times. What did I do wrong? How
can I make it ask for the input only once?

The simplest way is to not use a [Enter value:] prompt at all. Instead, use a
Form (let's call it frmCrit) with unbound controls (txtCrit let's say), and
use a criterion

=[Forms]![frmCrit]![txtCrit]

as a criterion.

It's handy to put a command button on frmCrit to launch the report, so the
user doesn't need to see the database window at all.