cascade combobox in a subform

D

deb

Please help, with a cascade combobox in a sub form.

I would like make a selection from the combobox named cboSiteID in my main
form named f4Project and have the combobox named cboUnitID in my sub form
named t032ProjUnit be limited to only the records relating to the SiteID.

How can this be done?

Thanks in advance!!
 
S

Scottgem (MVP)

deb said:
Please help, with a cascade combobox in a sub form.

I would like make a selection from the combobox named cboSiteID in my main
form named f4Project and have the combobox named cboUnitID in my sub form
named t032ProjUnit be limited to only the records relating to the SiteID.

How can this be done?

Thanks in advance!!
Click to expand...
Yes, You just need to reference the main form control by setting the
criteria in the Rowsource to:

=Forms!formname!controlname

You will also need to requery the subform control either after update of
the mainform control or when the subform control gets focus.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
 

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

delete records in subform if combo box changes 1
multiselect listbox to filter subform combobox 3
cascade combobox and auto populate fields. 11
delete fields in subform combobox after main form combobox is chan 4
if a ComboBox is null in a Form, must not allow a checkbox to be t 1
must select from combobox first 2
Automatic updating a combobox 3
Using Combobox to Sort subform 4

Top