After update reset form (1 Viewer)

[cktcPeterson]

Hello

I have a main form frmStudentCheckIn and a subform frmSubCheckin and a field [Select Course]

Currently, I have a combo box in the form header where students can select their name and then on the subform can select the course they are taking.
I need help with- After they select their course I want to return the combo box and clear it for the next person.

Thanks!

 

[pbaldy]

Presuming the form is bound try using GoToRecord to move the main form to a new record and SetFocus to move focus to the combo.

 

[theDBguy]

Hi. Welcome to AWF!

Are you able to post a screenshot of your forms?

 

[Eugene-LS]

After they select their course I want to return the combo box and clear it for the next person.

Private Sub SubFormCourseSelection_EventName()
    '... Saving selected data ...
    '...
    ' return the combo box and clear it for the next person
    Me.Parent.Form.ComboBoxStudentName = Null
    Me.Parent.Form.ComboBoxStudentName.SetFocus
    Me.Requery
End Sub

Don't forget to replace the name of the event and the combo box with the real ...