Combo box row source

[human_anomaly]

I am trying to do something that I once knew how to do, but time and lack of using access has got to my memory. What I need to do is have a combo box that looks at a table, I want its rowsource to be column 1 of the table and the record I want recorded is what is in column 2. Basically column 1 is like an employee name and column 2 is like the employee number. I want the combo box to show the employee names in the list but store the employee number in the record. Can anyone remind me how to do this?

 

[dcx693]

In looking at the combo box properties, the "Bound" column is the column that is stored by the combo box, no matter what is actually displayed. In your case, set it to 2 to record the employee number. You can then set the "Column Count" property to 2, set the Column Widths to 1" (or however large you want the employee name column to be) and 0" for the 2nd column. Only the first column will then be visible.

 

[daveUK]

dcx693 beat me to it

 

[dcx693]

Yes, but I made one typo (which I corrected).

 

[human_anomaly]

thanks

Thank you very much, I had the bound column part but I was not changing the column count to 2. I made the column widths 1",0" and everything works great. Thanks