combo box with two tables?

[razoRjaw]

Ok, I have table A with email address and primary key autonumber. the email addresses are stored here.
next i have table B with other information that i want stored and a form for it.
there is one combo box on the form and i can see the email addresses from tableA, but when it stores them in tableB, the field has the autonumber value not the actual email address which i want pulled from tableA for that specific record.

whats the correct way to get the address filed to store instead of the autonumber?

thanks

[NeoPa]

Look at the properties of the ComboBox.

Your .ControlSource property is fine, but you need to ensure that the .RowSource and the .BoundColumn properties are set up to match and to return the text value rather than the AutoNumber field.

You should be careful also to ensure .ColumnWidths is set correctly too.

[razoRjaw]

you sir are a genius.
it was the .boundcolumn that was giving me the trouble. I was unaware that the bound column is refering to the query built on the combobox, I thought it was looking at the table!
just solved 2 days of frustration.

[NeoPa]

Very pleased it was that straightforward razoRjaw :)

Have fun with your project.