By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,762 Members | 1,836 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,762 IT Pros & Developers. It's quick & easy.

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

P: 2
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.

Dec 27 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 108
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 -
Dec 27 '07 #2

P: 2
Thanks a million for your help - and pointing me in the right direction to learn more, I really appreciate it.
Dec 29 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.