Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 20th, 2004, 06:37 AM
Registered User
Join Date: Aug 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using lookup tables in Access


I think this should be easy () but I cannot see away to do it.

In one of my data-entry panels I need to present the inputter with a series of options in text so that they can read it and decide what one to pick. However, I need a specific value to be entered in the database.

I envisaged something like the following

Text Value
Label 1 "200"
Label 2 "210"
Label 3 "220"
... "..."

The person entering data would see a drop down list containing the various labels in column one. S/He chooses on and the associated value in column 2 is passed to the database. The inputter would only see the labels from column 1 and the mechanics of the database would do the conversion from label to value and enter the value in the database.

Sounds like it should be doable (:D). If I use a web page to enter the data then the whole thing is very easy, but...

Old August 20th, 2004, 08:14 AM
Friend of Wrox
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc

It sounds like your are looking for a combo box or list box

Depend on which version of access you have look up help information on
"About creating a list box, combo box, or drop-down list box that looks up values". create your drop down list on the form and try not use look on the table.

Old August 20th, 2004, 08:18 AM
Registered User
Join Date: Aug 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts


Thanks for that. I am using Access 2000. I'll have a look again and see if i have missed anything.

Old August 20th, 2004, 09:23 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG


Create a combobox on your form. The rowsource could be a table that has two fields. One is the label, one is the value.

Open the combobox's property window and set its number of columns to 2. Set its BOUND column to Column 2 (the value). Set the column widths to, say, 1"; 0". This will hide the values and only show the labels.

Because the bound column is the second one, when the user chooses a label, Access will use the value (not the label) in its calculations.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Old September 18th, 2004, 05:39 AM
Registered User
Join Date: Aug 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts


Got round to doing it your way. worked thanks

Head of innovation and Industry Services,
Faculty of Applied Arts

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Access Ms-Access WorkGroup tables using VB kishoremf BOOK: Professional Crystal Reports for VS.NET 1 April 29th, 2007 02:05 AM
creating tables within tables in access??? carswelljr Access 3 August 23rd, 2006 01:21 PM
Access Tables penta Access 3 August 21st, 2004 08:32 AM
Lookup Tables mossimo Access 4 December 5th, 2003 11:27 AM
Access Linked Tables StephenDID Access ASP 6 October 6th, 2003 10:08 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.