ListBox help

A

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
 
B

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.
 

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

Evaluate ListBox Value 8
Requery listbox 1
Listbox query 3
Open Form based on Listbox 2
Listbox beforeupdate 2
Get displayed text from ListBox? 2
Clear Multiselect listbox 14
Optionbutton Not working 3

Top