Query is not picking up data from subform

  • Thread starter Thread starter Jen
  • Start date Start date
J

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
 
Jen said:
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?
Click to expand...

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.
 
-----Original Message-----
Jen said:
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?
Click to expand...

That syntax actually needs to have the name of the
Click to expand...
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
Click to expand...
is not a multiselect. What else could be the problem?

Thanks,
Jen
 
Back
Top