Combo box - 1st record selection

[Glynn]

I have a combo box to select the records to appear in a Form.

Upon opening the Form, the 1st record is automatically selected - whereas I
want the form to open in blank - and a record to appear only after the user
selects the record in the Combo Box.

Appreciate help.

 

[Ken Snell \(MVP\)]

Add a WHERE clause to the form's RecordSource query:

WHERE FieldName = Forms!NameOfForm!NameOfComboBox


Then, use the AfterUpdate event of the combo box to requery the form:

Private Sub NameOfComboBox_AfterUpdate()
Me.Requery
End Sub