mult-prompt reductions

  • Thread starter Thread starter rrosado
  • Start date Start date
R

rrosado

I have a report I open but the report I open has sub-form that are all
connected to the same org. query. Problem is I have a prompt on the
org. query, so now when I open the report I have tons of prompts, all
requesting the same prompt. How do I get access to just have one and
all sub-form contect to that prompt?
 
one solution is to use a control on a form to enter the same response you
have been entering in the query prompt. change the prompt in the query
criteria to a reference to the form and control, as

[Forms]![FormName]![ControlName]

replace FormName and ControlName with the correct names of the form and the
control, of course. note that the form must be open when you open the
report, so the value in the control is available to the query when it runs.

hth
 
Back
Top