Auto Populate Field Not Working

[Chronus13]

Hello,
I have a small issue i am trying to figure out. I have a form that has a drop down list in a combo box. This allows me to select a name. I am trying to auto populate the name chosen into another box on another form. Seems to be working but I noticed i am getting the auto populate as a number instead of the Name i selected. It looks like it is auto populating the selection number. If i have 4 names and i select the third one for example, the auto populate will show "3" instead of the name. Any idea why this is happening? I am using the below:

=[Forms}![Form1]![Combo3] as the control source, Form1 is the form with the drop down listing while Combo3 is the name of it

thanks,
Wes

[Bob Fitz]

Try:
=[Forms]![Form1]![Combo3].Column(1)

[Micron]

Any idea why this is happening?

That is how it's supposed to be done if the number value is related to a primary field. That is, you store the PK (which I suspect in your case is an autonumber field) in the records of the many side of a one to many relationship, not the value you see in the combo (e.g. a name).

[Chronus13]

Bob,
I appreciate it, that fixed my issue.

[mike60smart]

Hi Wes

Maybe we should step back a bit and ask what is the purpose of the name field in the related Form?

Are you linking the underlying tables on the name field?

is the name field the FK of the related table?

If this is the case then the display of the Number is correct.

[Bob Fitz]

Bob,
I appreciate it, that fixed my issue.

I'm glad that you have a solution to your problem now but I hope that you have taken on board the point that Micron raised.
IMHO My proposed solution is fine as a method of giving information to a user but if you are intending to store information about this person in another table then you should save the number, which is I presume, the PK, rather than the text value.