Drop Down Menu

[JT Omaha]

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

 

[TonyT]

Provided you have a way of identifying which price relates to which program,
you should use the after update event of the first combobox to update the
rowsource of the second;

Me.cboProgram_AfterUpdate()

If nz(Me.cboProgram,"")<>"" Then
Me.cboPrice.Rowsource = "SELECT PriceID, Price FROM myTable/Query WHERE
IdentifyingInfo = " & Me.cbProgram & ""
End If
End Sub

TonyT..