You might be better off adding a column to the combobox (if you set that column width to 0, it won't be seen in the pulldown). Then your textbox source is like this:
=cboDescription.Column(2) This is faster, and if you are using a subform, you won't have all the values changing as you would with an unbound field. I'm assuming here that column 0 is the key field, column 1 is the one that shows, and column 2 is your description field. Tobi -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of brazilianbound Sent: Tuesday, December 13, 2005 2:15 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Using DLOOKUP I'm using DLOOKUP on a combo box to populate a txtdescription field. But I can't get it to update automatically without physically hitting the "F9". Is there a way to automatically update this field after changing the value in the combo box? Thanks! CODE =DLookUp("CostCenter","ScanCC_Qry","Forms!SCANFORM! OpNum=ScanCC_Qry.CostCenterNo") Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/2jUsvC/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/
