Automatically populate a field from a Combo box selection 1

[liamm]

Hi, I am trying to populate a field on a form automatically from a combo box selection.
I currently have 2 tables:

tblPIDList - PID Number (text & key) & PID Title (text)
tblEIPList - lots of fields

When I create a form for the tblEIPList I want to have a combobox which looks up the PID Number from the tblPIDList and automatically populate a field (text box I think) with the relevant PID Title

So far I cannot get the text box to populate automatically.
Hope this makes sense

If you can help, GREAT
If I can help, EVEN BETTER

 

[Remou]

One option is to include two columns in the combo, PID Number and PID Title. Set the column widths to say, 2cm; 0cm
Set the Control Source of the textbox to:
= Me.Combo.Column(1)

 

[liamm]

Thanks Remou, but this doesn't appear to work for me. I get a #Name error in the text box

Liam

If you can help, GREAT
If I can help, EVEN BETTER

 

[Remou]

It's the dratted Me, in a textbox, the Me needs to be left out:

[tt]=[Name Of Combo].Column(n)[/tt]

 

[liamm]

Remou,thanks very much. It may have been simple for you but has saved me loads of hassle

Liam


If you can help, GREAT
If I can help, EVEN BETTER