Openform with Wherecondition causes Parameter entry request

A

Ace9x

When calling a 2nd form based on a query/table join with a wherecondition
clause, I keep getting a Parameter entry request for the 2 parameters built
as part of the where clause. The clause statement looks fine prior to the
Openform. On the called form the Record source statement uses the query in
the FRom statement.

I have looked all round the 2 forms to try and discover why the parameters
are requested when the forms are run to no avail. I have obviously messed up
somewhere along the line. Any one point me in the right direction please.

Cheers,
Steve
 
M

Michel Walsh

Hi,

It is not clear, but is it possible you have no problem when you use the
form alone, but have a problem when you use it as subform? If the parameter
is with the syntax:

FORMS!formNameHere!ControlNameHere


that works only if the form is use as a principal form, NOT as a subform.


FORMS!MainFormName!SubformControlName.FORM.CONTROLS!ControlName


is an appropriate syntax to reach a control in a subform. The
SubformControlName is the name of the control, not necessary the name of the
form used to "fill it".


Hoping it may help,
Vanderghast, Access MVP
 
Top