To have combo box blank when form opens?

[JeffreyDavid]

I have a form, a combo box and some text boxes. When I click on the combo box, it shows multiple fields in the table and when I select one, it populates the combo box and the appropriate text boxes. For some reason, when I open the form, the combo box displays a name from the middle of the drop down list. Its not the last one used, nor is it at the begining of the list.
How do I get that to open blank?

 

[doran_doran]

Try this..

Not sure if you are asking for following. But try it if it works then great.

go to form properties and go to load and type [event procedure] then click on the ... to open the visual basic editor.

put following. (asssuming your combo box name combo1)

me.combo1.value = null

or

me.combo1 = ""

or

me. combo1.value = ""

Either one of the above should work.

 

[ozsupra]

Addit:- You will find that the ComboBox remembers the last entry when reopening (before running "OnLoad") so it is good practice to add the same code to the form "Close" process