Updating Multiple Fields from a Combo Box 1

[Smeg77]

I have a Combo Box that is run from a simple query.

All it does is look up the Workers from tblWorkers and gives me a list of the names.

Currently I have it set so that the ComboBox records this value in on of my table fields, and I would also like to do is get it to record the ID value from that query into a second field, is this possible.

Here's an example of what I'm after;

ID| F-Name| S-Name| Name
1 | Joe | Blogs | Joe Blogs
24| Jane | Doe | Jane Doe

Currently the Name Field goes into Table_Name in the table, and what I'd like is for the ID value to go into another field Table_ID

 

[PHV]

Use the Column property of the ComboBox, eg in the AfterUpdate event procedure of the combo:
Me!Table_ID = Me![name of combo].Column(0)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Smeg77]

PHV Thanks for that, such a simple little solution, but one that has been doing my head in.

It works a treat so thanks again