Solved SubForms (1 Viewer)

[Teri Bridges]

I have a main form which has a field ModuleID. This is a selection field.
I would like the dropdown list on my sub form to limit the options based on the Module ID selected on the main form. Is that possible?

I tried to do it in the query but was not successful.
[forms]![updateCourseDetails_Frm]![moduleID]

 

[Gasman]

Rewuery the combo in the AfterUpdate of that control.

 

[Teri Bridges]

I have a main form which has a field ModuleID. This is a selection field.
I would like the dropdown list on my sub form to limit the options based on the Module ID selected on the main form. Is that possible?

View attachment 110672

I tried to do it in the query but was not successful.
[forms]![updateCourseDetails_Frm]![moduleID]
View attachment 110673

Naw, I am doing something really wrong I cannot even get the query to run.

 

[Gasman]

Forms: Refer to Form and Subform properties and controls

 

[Teri Bridges]

Forms: Refer to Form and Subform properties and controls

Thank you. I finally got it to work!