Combo box defaultvalue

[rickyfong]

I got a COMBO BOX with 2 columns , for instance code and name.

CODE NAME
123 JOHN
124 JACK
125 BILLY
126 MARY


In the OPEN form action which the form using this combo to do some query action, I want to put a default value to this combo box after a VBA query result of which should return a name to this form. Just want to know how to put the result to this combo box, e.g. when the VBA query return a name Billy. What's the syntax to make this combo box equal to Billy and do corresponding query?? Thans a lot!! FOr the time being I just know the following syntax, but since the combo box got 2 columns and how can I know Billy is located in the third record?? Thanks !!

Me.Combo24.DefaultValue = "FORMS![Master]![combo24].itemdata(0)"

 

[Isskint]

hi nicky

i take it that 'code' is the bound column? if so you need to dlookup() that code based on the name returned from your VBA query (if both of these are in table).
You can use me.combo24=dlookup()