Combo box with ID and Name

[555446666]

I have a SQL statement that brings back two fields - ID and Name.  The combo box is bind with the Name fields.  Upon the user selection How can I pull the ID field.

Newbie...

[Former Community Member]

You have to make a second call using a SQL statement to retrieve the right record. There is a good description of this on Stefan Cameron's blog.

http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/

Paul