Cascading Queries

L

l.a.spates

HI all,

I'm looking for some advice on what I think are cascading queries.
Here's what I want to occur in my database:

I have a main table (Partner Table) which has a field titled
"Category". The "Category" field offers 4 options in a drop-down list.
When the "Diversity" option is chosen from the "Category" list, I want
another field (column) in the table to open and offer another drop-down
list for more detailed choices (ie. African-American, Hispanic etc.).
So, for example: I get to the "Category" field in my "Partner Table"
and I choose "Diversity." A new column should appear that offers me
options for which type of Diversity Group my entry is.

Is this possible? I think I am trying to achieve either cascading
quieries, parameters or updates. Is this right? If so, can someone give
me some guidance? If not, in which direction should I be headed? I am a
new, self-taught Access user and could use some advice!!!

Thanks.
 
A

Al Campagna

LA,
You could place the cboRace on the form, but disble or enable it according to the value
of cboCategory.
Use the AfterUpdate event of cboCategory...
cboRace.Enabled = cboCategory = "Diversity"
Also, place that same code in the OnCurrent event for the form. As you browse from
record to record, cboRace will enable/disable accordingly.
 
Top