Form opening = unwanted para request

[ppoindexter]

i have popfrm_B which passes criteria via Combo1 to frm_A 's query populating many fields on frm_A

using [Forms]![popfrm_B]![Combo1] in the Criteria field of the appropriate field

popfrm_B opens via CommandOpen which is placed on frm_A

all works well except, when i open frm_A, i get

Enter Parameter Value
Forms!popfrm_B!Combo1

can someone provide a way around this request for the para
thanks

 

[WayneRyan]

ppoindexter,

Your Form A is based on a query that references
a combo box on Form B. Form B must be open,
otherwise (as you know), you will be prompted
for the parameter.

You can have Form B open and minimized (or
hidden) before Form A opens. That should
get rid of the problem. The default value in
the combo can be the 1st record for form A
or maybe an "*" for all records.

Wayne

 

[ppoindexter]

Thanks Wayne