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

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

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
Who is Participating?
omgangIT ManagerCommented:
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
jtovar3Author Commented:
Perfect. Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.