ListBox help

[alex]

Hello,

Using Access ’03…

I have a bound listbox on a subform that uses a query as its row
source. In that query, I’d like to use the value of another bound
listbox (on the same form) in the criteria.

Can I do that?
This does not seem to work: [forms]![mysubform]![lstbox]

I know that I can use the value of an unbound listbox on the main
form.

Thanks,
alex

 

[Beetle]

The syntax for referring to a control on a subform is;

Forms!MainForm!SubformControl.Form!NameOfControl

SubformControl refers to the control (the window) that holds
the subform, which may, or may not, have the same name as
the subform itself, depending on how you added the subform.