Autofill a textbox in a form based on the data in a combobox on the same form

[Access Knowledge]

I would like a textbox to be autofilled with the extension number of the employee that is chosen from a combobox in the same form. I have the data all entered in two tables but I cannot figure how to relate the two sets of data so that the textbox will autofill based on the chosen employee. Can someone help me out here? I'm almost pulling my hair out trying to figure out if I went wrong or if I'm just missing a step. Thank You

[CJ_London]

in the rowsource to your combobox, include the extension number. Assuming your combo has three columns (ID, name, extension), you will have hidden the first and last columns and your combo control is called cboEmployee, in your textbox controlsource put

=cboEmployee.column(2)

[pbaldy]

How about:

BaldyWeb - Autofill

[pbaldy]

ACK! This is what happens when the phone rings while you're typing, and you don't refresh. Sorry Ajax.

[CJ_London]

no need to apologise - happens to me to!

[Access Knowledge]

Thank you guys for your help but I'm still having trouble. What I have is one table title MLS Employee with 3 columns (ID, Name, contact) From their I have a form where the combobox titled "Assigned To" has a lookup feature for the "name". What I would like is the textbox titled "Employee Contact" to fill automatically the "contact" for that specific "name".

[pbaldy]

Looks like Ajax is off duty. What exactly does "having trouble" mean? Have you tried the suggestions? Both involve including the desired field in the combo row source, then either copying or referring to that value.

[Access Knowledge]

I played around with what you guys recommended and what I had and I finally got it to work.
Thanks again

[pbaldy]

Ajax was happy to help and I was happy to pile on.

Welcome to the site by the way!

[CJ_London]

Sorry missed the exchange - was out having a life