Control Source Dependent on Combo Box Brutalius 12/23/2008 9:06:08 PM Hello, I have a drop-down list on a form with several years (2005, 2006, 2007). I also have a Table which has 3 columns of data (i.e. for 2005, 2006 and 2007). I would like the control source of a single text box on the form to be dependent on which year is selected. Any idea how to do this? Thanks!

Re: Control Source Dependent on Combo Box "Damon Heron" <damon_327[ at ]hotmail.com> 12/23/2008 11:26:03 PM The dropdown list is a combobox not tied to the table, correct? In other words, you have a value list for the combo box of "2005";"2006";"2007". In the after update event of the combobox, have this code: Select Case YourComboboxName 'substitute your cbo name Case "2005" Me.Text8.ControlSource = "YourtblName.2005" 'sub your table and fieldname Case "2006" Me.Text8.ControlSource = "YourtblName.2006" Case "2007" Me.Text8.ControlSource = "YourtblName.2007" End Select End Sub HTH Damon "Brutalius" <Brutalius[ at ]discussions.microsoft.com> wrote in message news:B7765BD8-F04B-4FCF-808B-05FE34663C39[ at ]microsoft.com... [Quoted Text] > Hello, > > I have a drop-down list on a form with several years (2005, 2006, 2007). > I > also have a Table which has 3 columns of data (i.e. for 2005, 2006 and > 2007). > I would like the control source of a single text box on the form to be > dependent on which year is selected. Any idea how to do this? > > Thanks!

Re: Control Source Dependent on Combo Box Piet Linden <pietlinden[ at ]hotmail.com> 12/25/2008 3:05:33 AM On Dec 23, 4:06 pm, Brutalius <Brutal...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > Hello, > > I have a drop-down list on a form with several years (2005, 2006, 2007).  I > also have a Table which has 3 columns of data (i.e. for 2005, 2006 and 2007). >  I would like the control source of a single text box on the form to be > dependent on which year is selected.  Any idea how to do this? > > Thanks! Sounds like a non-normalized design... 2005-7 are Years, so you should not store those facts in column names. If you find yourself changing your table design to add more data, it's a sure sign that your design is flawed.