Go ahead and build the row source of your combo box. In the field where it indicates the column width, set it as 0"; 2". Then your department ID will be hidden, yet it will still be the bound column of 1.
Dawn Crosier Application Specialist "Education Lasts a Lifetime" This message was posted to a newsgroup. Please post replies and questions to the group so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of m2ns2n Sent: Sunday, March 12, 2006 12:43 PM To: [email protected] Subject: [ms_access] combo box Hello I want to creat combo box that have the department id and the department name and when I choose the value I want the department name to be shown in the feild not the department id best regards Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
