combo values

[mallorn]

Hello,
I'm very new in Access programming.
My problem is to show different values in combobox but save their number representation (I tried combobox record list but without success).

I mean:
1st_table: worker_ID, FirstName, LastName, ....
2nd_table: worker_ID, .....
My_Form writes values in 2nd_table directly.
I want to show on My_Form's combobox some strings combination of 1st_table columns (FirstName + " " + LastName - not a problem to show in SQL ) instead of worker_ID. But I want to write the worker_ID back in 2nd_table.

How to do it?

[pbaldy]

The bound column property of the combo determines which field is saved. Presuming your row source is

SELECT worker_ID, FirstName + " " + LastName AS FullName

you'd want the bound column to be 1. You can use the column widths property of the combo to hide the ID if you want.

[mallorn]

Works great, Thanks.

[pbaldy]

Happy to help, and welcome to the site by the way!