How to select field dependent on another field selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a form from which the user can select a list, and then
that selection will determine the next list given to select from.

For example. In the first list,
Operations
Information
Support
Projects
Meetings

If they select 'Projects', then they will have a list of projects to select
from next.
If they select 'Meeting', then they will select from a list of possible
meetings.

I've been trying to do this unsuccessfully using a combo box, but any other
ideas or suggestions on ways to do this would be appreciated. Thanks
 
I am trying to set up a form from which the user can select a list, and then
that selection will determine the next list given to select from.

For example. In the first list,
Operations
Information
Support
Projects
Meetings

If they select 'Projects', then they will have a list of projects to select
from next.
If they select 'Meeting', then they will select from a list of possible
meetings.

I've been trying to do this unsuccessfully using a combo box, but any other
ideas or suggestions on ways to do this would be appreciated. Thanks
Click to expand...

What is the structure of your tables? Do you have *FIELDS* named
Operations, Information, Support etc., or are these values *in* a
field? Given a user selection of "Projects", where would the list of
projects be found?

You can use a Combo Box to filter another Combo Box pretty simply -
but I'm not certain of your data structure, so I don't know exactly
what to suggest!

John W. Vinson[MVP]
 
Back
Top