ControlSource.....................NONE RowSource........................ v_Weeks.Wk RowSourceType................. 6 - FieldsComboBox 2 (CboEvents) gives a list of events that will occur on the cboWks selection..
ControlSource.....................NONE RowSource........................ v_Events.Event RowSourceType................. 6 - FieldsAs different weeks are selected from cboWks, I need to requery the events table for the events for that week
WITH thisform * Set the view parameter for Events Object to the week highlighted .EventsObj.cWk = this.value * Requery the EventsObj .EventsObj.requery() * Set the resulting view to the top of the list SELECT v_Events LOCATE * Now requery the events Combo .cboEvents.Requery() * Refresh the ComboBox .cboEvents.Refresh() ENDWITHIt is a fine looking and powerful form now and