multiple choices based on combo box selection

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I have a from called status which contains a combo box
which lets the user enter a status description that they
pick from a combo box. The combo box reads the status
choices from a separate table, that I've called 'Status-
pick list'.

Based on what status the user picks, I want to be able to
give them a second group of items to choose from somehow
(in another combo box or something). eg if they pick X
for the status description, then they should then be
presented with a choice of A1, B1, C1. if they pick Y for
the status description they should then be presented with
a choice of A2, B2, C2, and if they pick Z there will not
be any more information required.

Can anyone help?
 
Hi ,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

I think the following Knowledge Base article is what you are looking for:

ACC2000: How to Synchronize Two Combo Boxes on a Form

http://support.microsoft.com/default.aspx?scid=kb;en-us;209595

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top