Using a parameter

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?
 
K

Ken Snell

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab 3
control name literal 1
Active Event 2
Opening a dialog in a more helpful position 1
A form within a form in 2005 6
Passing values between forms 2
Can a form tell another form to add a record? 4
set value in subform 4

Top