I think Tobi understood perfectly. What he said is you can have multiple columns in your combo. Adjust your query that populates your combobox so that your "CostCenter" column is included. Then set the column widths for your combo box so that the CostCenter column is width 0" so it doesn't show. Then you can set the source for the txtdescription textbox to
==cboDescription.Column(2) This assumes that CostCenter was the 3rd column in your combobox query (first column is index 0, second 1, ...) Can you be more precise when you say it "didn't work"? Did it not fill in the textbox? Did it fill it in wrong? Do you still have to hit F9? If the original way you had it was working to your satisfaction, it may only need a txtdescription.Refresh (or .Requery). HTH, Toby ----- Original Message ----- From: "brazilianbound" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, December 13, 2005 12:44 PM Subject: [AccessDevelopers] Re: Using DLOOKUP > Hi Tobi - > I tried it as you stated but it didn't work > As usual, I think that maybe i wasn't clear enough when describing > my problem. I have an unbound text box called txtdescirption. It's > populated off of my combo box OpNum. What I want it to do is when I > enter my value in the OpNum combo box, that the txtdescription would > update with the correct description. > > Thanks Tobi! > > --- In [email protected], "Hoffman, Tobi K \(DYS\)" > <[EMAIL PROTECTED]> wrote: > > > > 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: [email protected] > > [mailto:[EMAIL PROTECTED] On Behalf Of > brazilianbound > > Sent: Tuesday, December 13, 2005 2:15 PM > > To: [email protected] > > 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 > > > > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > > > > -- > BEGIN-ANTISPAM-VOTING-LINKS > ------------------------------------------------------ > > Teach CanIt if this mail (ID 27029941) is spam: > Spam: http://web2.cleanmessage.com/b.php?c=s&i=27029941&m=0f66be25a3a6 > Not spam: http://web2.cleanmessage.com/b.php?c=n&i=27029941&m=0f66be25a3a6 > Forget vote: http://web2.cleanmessage.com/b.php?c=f&i=27029941&m=0f66be25a3a6 > ------------------------------------------------------ > END-ANTISPAM-VOTING-LINKS > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/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/
