The form contains a sub-form with a solitary combo box to be able to select a sub-group of the combo box on the main form.
I have the following code in the row source of the subform:
Expand|Select|Wrap|Line Numbers
- SELECT [Class Times].[Class ID], [Class Times].Class
- FROM Members LEFT JOIN [Class Times] ON Members.Class = [Class Times].Class
- WHERE ((([Class Times].Class)=[Forms]![Form - Current Members]![Class]));
Expand|Select|Wrap|Line Numbers
- Private Sub Class_AfterUpdate()
- Forms![Form - Class Register Subform]![Class ID].Requery
- End Sub