Reset combo box to blank or non selectable value in list

[Design by Sue]

On my unbound form I have a combo box with a record source type set to value list and the record source with two choices in it. I would like the combo box to reset back to either blank or a the phrase "select one" once a record is saved. If it shows "select one" I do not want the user to be able to actually select that. As I said the form is an unbound form and I have used the coding of "insert into" to save the new record to a table. I have been able to clear the text box on this form when the new record is save by resetting it's value to "" but have been unable to reset the combo box to blank.

So the question is how do I reset the combo box through code after a save to display nothing - or is there a way to add a non-selectable choice to the list and have it display when the form is refreshed.

Hoping that makes sense.

Sue

 

[bob fitz]

What happens if you try to set the value to Null or "" after running the query that saves the record.

 

[Design by Sue]

Sure enough that worked - was sure I tried that before with no luck. Set it to ""

Thank you again

 

[Design by Sue]

Realized what I needed to do - it was that I actually had to put the code after a refresh I had in the form - putting it before did not work

 

[bob fitz]

Sure enough that worked - was sure I tried that before with no luck. Set it to ""

Thank you again

You're welcome. Glad to help.