Main and Sub Menu

C

charles

I have a database of "artefacts".

An Artefact has a "Main Type"...and a "Sub Type"
e.g with "Main Type" = "Document"
"Document" has "Sub Types" e.g. "Book, Magazine, Newspaper, Certificate,
etc...

I want to let the user select the "Main Type" of an Artefact
and then, they need to be able to select from a "Sub Type".

Eg. If the Artefact "Main Type" was a "Video" they could only
select "8mm Film", "Tape", "DVD"

How can I arrange a Form so that the relevant "Sub Type" is
available from a Drop down menu when the "Main Type" has been chosen.


Thanks


Charles W.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main form and loading a few subforms 8
Link subform with main form 0
Menu Ideas in Access 2010 0
Sub query - select according to main query 2
Sub Menu 1
multiple default value in a field 2
Automatically select in a sub form by a number chosen in the main 1
How do you .DELETE a (sub-menu) Control that was clicked? 2

Top