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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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 = ""
 
Also, if you don't want the combo to display any thing while clicking on it,
then set the rowsource to ""
Me.ComboName.RowSource = ""
 
Back
Top