Pull 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

 

[Al Campagna]

JT,
See my reply in the Microsoft.Public.Access newsgroup.
Please don't post the same question in different newsgroups. Someone
might be answering in M.P.A.Forms while someone else is answering in
M.P.Access.
If you must "crosspost" (it's not yet a federal crime :-D) just include
all the newsgroups in the "To."

Microsoft.Public.Access ; Microsoft.Public.Access.Forms; etc...

Any response to will be seen in all groups indicated in the To.
--
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."