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


--
deb

deb wrote:
> 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

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/...UBED1=ACCESS-L


"deb" <deb@discussions.microsoft.com> wrote in message
news:7AC95421-EF7B-4A24-96CA-9AD6CB669FC1@microsoft.com...
> 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!!
>
>
> --
> deb

dans l'article OV3#e#UfIHA.5208@TK2MSFTNGP04.phx.gbl, Scottgem (MVP) à
scottgem@hotmail.com a écrit le 3/03/2008 17:57*:

> deb wrote:
>> 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

"enzo mallard" <mallard.enzo@neuf.fr> ha scritto nel messaggio
news:C430F8B9.1BF2%mallard.enzo@neuf.fr...
> dans l'article OV3#e#UfIHA.5208@TK2MSFTNGP04.phx.gbl, Scottgem (MVP) à
> scottgem@hotmail.com a écrit le 3/03/2008 17:57 :
>
>> deb wrote:
>>> 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
>