How to Display Text but Capture unique ID in a combo box
Posted on 2011-02-28
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]
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