Update field in table based on combo box

[kmkb]

I have two tables. One table contains name_id, first_name and last_name. A form inputs information into the other table which also contains name_id.

I use a combo box in the form containing name_id, first_name and last_name from the first table. I want this selection to update the name_id field in the second table, but I get an error stating that I am trying to put text in a numeric field.

 

[Maquis]

Which column is the bound column in your combo box? It should be name_id (Column 0 probably). That is the field which will be stored in the record source of your combo box.
Maq B-)
<insert witty signature here>

 

[kmkb]

That was my problem. Thanks so much!