Solved

How to Display Text but Capture unique ID in a combo box

Posted on 2011-02-28
3
327 Views
Last Modified: 2012-05-11
Hello! I have such trouble phrasing my questions so please forgive the short sentences. Hopefully it will make it easier to understand.

I have a form with a combo box. I want the combo box to pull information from a table. this table (tbl_Groups) only has two columns (GRP_ID, GRP_Name).

The control source is GRP_ID

Row Source contains this Query:
SELECT [tbl_Groups].[GRP_ID], [tbl_Groups].[Grp_Name]
FROM tbl_Groups
ORDER BY [Grp_ID];

I'd like the combo box to show the group name but capture the grp_ID so that it can fill out a separate table when I add a record.

I hope this makes sense! Thanks! using access 2007
0
Comment
Question by:jtovar3
3 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 500 total points
ID: 34999052
0
 
LVL 28

Expert Comment

by:omgang
ID: 34999064
Set the column width for the first column (GRP_ID) to 0".  The second column will be displayed but the first column will still be the bound column.
OM Gang
0
 

Author Closing Comment

by:jtovar3
ID: 34999177
Perfect. Thanks!
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question