SubForm won't display Text, Only primary key (sorry, i'm new)

I have just barely started using access, and am trying to add a location column into an inventory program in Access 2003.

I have a table for local location names, for example "Denver" or "Portland". this table is used as a pull down menu for choosing the location of a specific transaction in an inventory table. In my inventory Table, all locations are shown in text

However, when i go to insert this data into my sub-form, it only shows the primary key # of the corresponding city, and refuses to let me enter text into the field.

you have no idea how silly i feel asking this, but any ideas on what i need to do to get this field to show text?

I really appreciate anybody willing to help out a newbie on a simple question.

thanks

re: SubForm won't display Text, Only primary key (sorry, i'm new)

Don't feel silly as we all had to start at the beginning.

As for you issue of only seeing the primary key it sounds like you are using bound combo box for the record lookup as you said. However, it seems that you have it looking at the wrong bound column. If you know where this is in the properties window (accessible by pressing Alt+Enter when on the control) you can change it to the correct column. Though as you said you're just beginning in access I would recommend reading up on combo boxes a bit in the help file or a turtorial so you can expand your knowledge beyond the scope of this problem.

Hope this helps.

- Minion -

re: SubForm won't display Text, Only primary key (sorry, i'm new)

Thanks a million for your help - and pointing me in the right direction to learn more, I really appreciate it.