The requery was just what I needed! I updates after each time i change it!
Thank you, thank you, thank you! Clayton --- In [email protected], "Toby Bierly" <[EMAIL PROTECTED]> wrote: > > 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 --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/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/
