All; I have a question. I have a form based on a table with just sales quotes and dates. I am using the salesquote as a combo box to select cooresponding records in a subform.
Works fine. But not the mgr says his users get confused when they are making changes in the subform which record they are changing so they want when they select a record from the combo box and the records appear in the subform; they want the combo box to go blank. I am not sure how to do this because if I reset the combo box to go blank; the subform records will go blank as well. Is there a way to do this?
Code:
Private Sub cboSalesquote_AfterUpdate()
Me.Filter = "[salesquote]=" & cboSalesquote
Me.FilterOn = True
End Sub
Works fine. But not the mgr says his users get confused when they are making changes in the subform which record they are changing so they want when they select a record from the combo box and the records appear in the subform; they want the combo box to go blank. I am not sure how to do this because if I reset the combo box to go blank; the subform records will go blank as well. Is there a way to do this?