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/> com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs. <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] ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/6pRQfA/fOaOAA/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/
