second combo box based on the selected of the first combo box 1

[tnguyen315]

Hello,
I have 2 combo boxes named "Divisions" and "Sections". Second combo box is based on the selected of the first combo box. It's is working fine when I open the form itself. However, when I put this form on another form use subform on the second tab. When click on this tab, I got an error pop up with "Enter parameter value: [Forms]![_frm_Volunteer_TimeTracking_sfrm]![Divisions]" . Please help.

Second combox:
Row Source =
SELECT tblSections.SectionCode, tblSections.SectionName FROM tblSections WHERE (((tblSections.DivisionCode)=[Forms]![_frm_Volunteer_TimeTracking_sfrm]![Divisions])) ORDER BY tblSections.ID;

 

[dhookom]

You need to understand how to reference controls on subforms. The Main form must be included followed by the name of the subform control name which is often the same as the source document.
[tt]
[Forms]![MainFormName]![_frm_Volunteer_TimeTracking_sfrm].Form.[Divisions]
[/tt]

Duane
Hook'D on Access
MS Access MVP

 

[tnguyen315]

Thanks dhookom, it worked
[Forms]![MainFormName]![_frm_Volunteer_TimeTracking_sfrm]![Divisions]
I'm very appreciated.
Thanks.