Automatically Populate Text Box with Primary Key Value

[MFS]

Here is what I am trying to do, I'm hoping that it is simple, but for some reason I cannot figure it out.



The table I am working with has two fields.
One for the Automatic Number, Primary Key, for each record. For this thread I will call it Container_Id
The other field I have named as Container_Size.

On my form, I have a Combo Box that shows all records of my container sizes. What I need is for a text box to automatically show the value of the Primary Key for whichever container size I choose.

Can this be accomplished?

Speck

[June7]

Why? Autonumber primary keys generally can be kept hidden because they seldom have any meaning to users.

However, what is actually being saved from the combobox? Are you saving the ID or the size? If you are saving the ID then can simply set a textbox ControlSource to the field. Lock the textbox if you don't want users to edit. If you are saving the size then the ID serves no purpose.

[MFS]

June7,

I reference the Primary Key number within a Programmable Logic Controller, PLC. (Much easier to send whole numbers to an integer file than a physical dimension.)

My combo box shows container sizes, when an operator chooses a 20x20 container I need a text box to show the primary key.
How can this be performed?

[June7]

Didn't really answer my question. Regardless of what the combobox shows the user, is the combobox saving the ID or the size? What is the combobox RowSource?

[MFS]

Saves Container_Size

[June7]

So the ID is not used as PK/FK in your db. It has some other purpose. Since you save the Size text info, that is the PK. To prevent duplicate Size entries in the Sizes table, the Size field should be set as PK or at least an index (no duplicates).

Recommend you set the combobox as multi-column:

RowSource: SELECT Size, ID FROM tblSizes ORDER BY Size;
ColumnCount: 2
BoundColumn: 1
ColumnWidths: 1";0"

Then expression in textbox can reference the ID column by index - index begins with 0:

=[cboSizes].[Column](1)

[MFS]

Thank You again for your help June7