cascade combobox in a subform

[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!!

 

[Scottgem (MVP)]

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!!

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

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CascadingComboBoxes.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[enzo mallard]

dans l'article OV3#e#[email protected], Scottgem (MVP) à
(e-mail address removed) a écrit le 3/03/2008 17:57 :