How do you get a combo box to display a blank on update

[Guest]

I have a combo box (1) which displays a list based on the information in
another combo box (2). When I click on the dropdown arrow of combo box (1)
and click a second time no choosing one of the items on its list, I want the
combo box to display a blank. How do I do thiis?

Thanks, Walt

 

[Guest]

Its depend on the type of the field
On the after update event of combo1 write the code

For number
Me.Combo2Name = Null

For text
Me.Combo2Name = ""

 

[Guest]

Also, if you don't want the combo to display any thing while clicking on it,
then set the rowsource to ""
Me.ComboName.RowSource = ""