Combo box

[hmurti17]

I have a subject table (in MS ACCESS) having two fields subject id and subject name. I want both the fields should be displayed in one combo box.

I want it at run time.
ie Combobox.Additem (rs("subname")).This displays only the subject name. I want the subject id field also to be displayed in the same combobox

I will be thankful if someone could solve my problem.

[John G Duffy]

You can concatenate the two fields together into one line in the combobox like so:

' example seperates two fields with a couple of blanks.
Combobox.Additem rs("subname") & " " & rs("subid")




John G