Query is not picking up data from subform

[Jen]

Hi! I have a query that needs to pick up a parameter from
a subform. I have the criteria written as follows:

[Forms]![MainForm]![SubForm].[Form]![ListBox]

Could someone please explain why this isn't working?

Thanks,
Jen

 

[Rick Brandt]

Hi! I have a query that needs to pick up a parameter from
a subform. I have the criteria written as follows:

[Forms]![MainForm]![SubForm].[Form]![ListBox]

Could someone please explain why this isn't working?

That syntax actually needs to have the name of the subform *control*, which is not
necessarily the same as the actual form embedded inside it. The names are "usually"
the same, but not always.

Also...ListBox isn't Multiselect is it? If it is it will never have a value.

 

[Jen]

-----Original Message-----

Hi! I have a query that needs to pick up a parameter from
a subform. I have the criteria written as follows:

[Forms]![MainForm]![SubForm].[Form]![ListBox]

Could someone please explain why this isn't working?

That syntax actually needs to have the name of the

subform *control*, which is not

necessarily the same as the actual form embedded inside it. The names are "usually"
the same, but not always.

Also...ListBox isn't Multiselect is it? If it is it will never have a value.


I do have the name as the subform control and my list box

is not a multiselect. What else could be the problem?

Thanks,
Jen