Using a parameter

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

I have a form (FormA) which has a subform(FormB). One of the listboxes on
FormB uses a query using a field from FormB as part of the where statement.
I've tried various versions of [forms]![FormA]![FormB].Form![PD_Date]
in the where statement. The query prompts for the value and if I enter it,
the query runs fine. When I try to run it on FormB, it prompts for the
value.

Can anyone let me know what I'm doing wrong?
 
Likely the name of the subform control that is holding "FormB" as the
subform is not named FormB. Open your main form in design view, click on the
top edge of the subform control that is holding FormB as the subform, open
Properties window, click on Name tab, and see what the name of the subform
control is. Use that name instead of FormB in the reference.
 
Back
Top