Drop Box Requirement

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

I have one drop box for: Department

"Department" drop box choses: Surgery
Medicine

I have another drop box for: Divisions

drop box choses: Geriatrics
Endocrinology
General Internal Medicine
Plastic Surgery
Oncology
QUESTION: When I choose Medicine, I would like only
certain Divisions to be allowed to be choosen.
Thanks in advance. DaveB
 
Please see my reply in microsoft.public.access.formscoding.

Rather than posting the same message to more than one group (multiposting)
please cross-post (send the one message to all groups at once). To
Crosspost, put all of the newsgroups into the Newsgroups field in the
message header. In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times.

See http://www.mvps.org/access/netiquette.htm for more information.
 
QUESTION: When I choose Medicine, I would like only
certain Divisions to be allowed to be choosen.
Click to expand...

Base the RowSource of the list box on a query, and put a WHERE criterion in
the query based on a reference to the first 'drop box' control, and then
call the list box Requery method in the AfterUpdate event of the 'drop box'
control.

If you need more help, please post back with table design and names of
controls, etc.

HTH


Tim F
 
Back
Top