Dave, Are you addressing the correct object of your text and combo boxes. Where John refers to "Me!txtCost1", that is the "name" property for that control (Properties->Other->Name).
If you use the same name for an unbound control as the name of the field data, Access won't know the difference. I'm not sure if that's your problem but John's code was bulletproof so there's got to be another reason if it doesn't work Brett DRR wrote: > Hi John: > > The suggestion you made seemed like it would be perfect but I can't > seem to > get it to put "any" value in a text box. I have the code in an > "AfterUpdate" > in the dropdown box. does that sound like the proper place? > > Thanks John > > =Dave R.= > > > > > > DRR- > > Use the Column property of the combo box. Column(0) is the first column, > Column(1) is the second, and so on. > > Me.txtCost1 = Me.MyCombo.Column(1) > > John Viescas, author > Building Microsoft Access Applications > Microsoft Office Access 2003 Inside Out > Running Microsoft Access 2000 > SQL Queries for Mere Mortals > http://www.viescas. <http://www.viescas.com/ > <http://www.viescas.com/>> com/ > (Paris, France) > For the inside scoop on Access 2007, see: > http://blogs. <http://blogs.msdn.com/access/ > <http://blogs.msdn.com/access/>> msdn.com/access/ > > _____ > > From: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com > [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> > ps.com] On > Behalf > Of DRR > Sent: Thursday, July 06, 2006 8:44 AM > To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com > Subject: [ms_access] Simple qusetion??? > > Hi All: > > This should be simple but at 2:24am I just can't jog my memory enough. Can > anyone help with a swift kick to the side of my head? > > I have a dropdown box with 3 columns. Column one is bound to a table field > when selected and that works fine. How can I "grab" the value in > column 2 & > 3 and put it into 2 other form fields. > > __________________ > ie: Drop down box contains | slip# | cost1 | cost2 | | > -------------------------------- > V > | 1 | 25.00 | 85.00 | > ------------------------------- > | 2 | 35.00 | 95.00 | > -------------------------------- > etc........... > > So I drop down, select the correct slip#. It grabs the slip# and puts > it in > slipnum field in the table. I would like to put the value of cost1 in a > separate "Cost1" UNBOUND field for display only and put cost2 in a BOUND > field and have the value go into "cost2" field in the table. > > I can't for the life of me remember how to reference (fetch) field 2 & > 3 and > stick them in two other fields. ESPECIALLY the bound field. It keeps > giving > me the value that's already IN the table. I think I'm supposed to know how > to do this but I also think I've been staring at this Database for too > long. > > Thanks...I seldom post here (But I GAIN much from reading) so I feel > like a > pest but really do appreciate ANY help. > > Thanks in advance for any sample code or suggestions. > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > -- Brett Collings Strengthening Families Administrator D2D 46422 DDI (04) 916 3422 ------------------------------- This email message and any attachment(s) is intended only for the person(s) or entity(entities) to whom it is addressed. The information it contains may be classified as IN CONFIDENCE and may be legally privileged. If you are not the intended recipient any use, disclosure or copying of the message or attachment(s) is strictly prohibited. If you have received this message in error please notify us immediately and destroy it and any attachment(s). Thank you. The Ministry of Social Development accepts no responsibility for changes made to this message or to any attachment(s) after transmission from the Ministry. ------------------------------- [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> 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/
