Refresh - requery - resummat

[Lanason]

As per usual I get stuck on simple Syntax. This one should be simple

I have a form with just one combo box showing outstanding orders based on a query.

The user enters the number (which must be outstanding as its limited to list)
then he hits a button to update the record and complete the order.
this bit works fine

but how do I refresh the form so that the entry combo box is empty and the query behind the combo box has removed the record that has just been updated banghead:

 

[tommycrock]

The answer is in your title!
Assuming the code is running from the form with the combo box in, try
me.comboBoxName.Requery
If that doesn't work, I would guess the record hasn't saved before this executes

 

[tommycrock]

Sorry, hadn't read the first part properly. So you need to clear the combobox first.
me.comboBoxName = Null
should do it

 

[Lanason]

Sorry, hadn't read the first part properly. So you need to clear the combobox first.
me.comboBoxName = Null
should do it

I tried a me.comboBoxName = "" but that didnt work