Pull Down Menus

[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

 

[Al Campagna]

JT,
Given cboPrograms and cboPrices...
Use the value selected in cboPrograms to filter the results of the query
behind cboPrices.
Example query behind cboPrices...
Price Program
=Forms!frmYourMainFormName!cboPrograms
On the AfterUpdate event of cboProgram... (I would Null out the cboPrices
whenever cboPrograms changes)
Me.cboPrices = Null
Me.cboPrices.Requery
That will keep Programs and Prices in "synch."

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."