On Mon, 28 Jan 2008 10:17:01 -0800, JT Omaha wrote:
> Hope I can word this right - any and all help will be much appricated.
>
> In my form I would like to have a Field, lets call it "programs." That
> field has a pull down menu that lets you pick one of four choices: Individual
> Training, Small Group Training, Team Training, or Other.
> Now, once a user clicks one of the four choices, say Team Training, the next
> field below, called "prices," changes a bit. The "prices" field, which is
> also a pull down menu, now only has prices for Team Training. Not all the
> prices for all the Programs.
>
> My question is, how can I set this up. How do I design the form to make
> those automatic pull down menu changes?
>
> Thanks for your help
Leave the 2nd combo box rowsource blank.
Code the 1st Combo box AfterUpdate event:
Me.Combo2.Rowsource = "Select Tablename.[Prices] From Tablename Where
Tablename.[Programs] = '" & Me.Combo1 & "'"
Change Tablename to whatever the actual name of your table is.
Change Combo1 and Combo2 to whatever the actual name of the combo
boxes are.
The above assumes the bound column of Combo1 is text.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail