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.