Clearing Combo Box when adding a new record

[Purdue_Engineer]

Does anyone know how to clear a combo box when adding a new record?

I have a combo box which searches for a customer by name, and then populates a form based on the name chosen.

The problem I have is when I go to add a new record to the form, the same name in the combo box remains from previously choosing it.

For example, if I choose Bill Jones to lookup and/or edit his information, and then want to save that and create a new record, "Bill Jones" remains in the combo search box. All of the other areas of the form become blank ready for a new entry except for the combo search box.

I have looked around the web for code and have used AfterUpdate code on the combo box to no avail.

Any help would be greatly appreciated!

Thanks

[pbaldy]

You should be able to set the combo to Null or "".

[Purdue_Engineer]

You should be able to set the combo to Null or "".

Where/how should I code that?

Thanks for the response.

[pbaldy]

With the search code. This type of thing:

  Dim rs As Object

  Set rs = Me.Recordset.Clone
  rs.FindFirst "[Acc_ID] = '" & Me![cmbFindDriver] & "'"
  Me.Bookmark = rs.Bookmark
  Me.cmbFindDriver = ""