Clear Combo Box (Access 2003)

Topic

New Reply

How do I get a combo box to show nothing when the form is opened. Now if I select something in the combo box – the next time I open the form the combo box still shows the same selection.
Thanks.

Reply | Quote

Replies

Is the combo box bound to a field in the record source of the form, i.e. does the Control Source of the combo box contain a field name?

Reply | Quote

Thanks Hans – got it working

Reply | Quote

Hi Robin

Is the form you created bound to a table or query?

If it is an unbound form you can use

Private Sub Form_Open(Cancel As Integer)
Me.FieldName = “”
End Sub

where FieldName id the name of your combo box

Reply | Quote

Thank you so much – got it working

Reply | Quote