Muliti-level Drop Down box

  • Thread starter Thread starter Thorson
  • Start date Start date
T

Thorson

Is there a way to make a muliti-level Drop down box?

So that when they click down on the box and select one option then multiple
other options become available.
 
Are you describing something like what you can do with "Cascading
Comboboxes"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
That must be what I need, I wasn't sure what to call it. I googled it and
found some great tutorials.

Thanks.
 
Is there a way to make a muliti-level Drop down box?

So that when they click down on the box and select one option then multiple
other options become available.
Click to expand...

The Combo data comes from where?
A Table or Query? A Value List?
"Multiple other options"?
What does that mean to someone who can't see your database nor read
your mind?
And the Field Name and the Datatype of the option is?

You'll make it a lot easier for us to help you if you give us relevant
information.

I'll assume you wish to select the Title of a person in Combo1
(Supervisor, Manager, Clerk) and then wish to show all Employees with
that title in Combo2, and that the values come from a Table or Query.

It's easiest to use 2 combo boxes.
Leave the record source of the second combo box blank.

Code the Combo1 AfterUpdate event:
Me.Combo2.Rowsource = "Select TableName.[EmployeeID], [EmployeeName]
from TableName Where TableName.[Title] = " & Me.Combo1

The above assums the bound column of Combo1 is a Number datatype.

If it is in fact a Text datatype, then use:

Where TableName.[Title] = """ & Me.Combo1 & """"

In the above if you select Manager from Combo1, all of the Employees
whose title is Manager will appear in Combo2.
Set the ColumnCount property of Combo2 to 2.
Hide the EmployeeID column by setting the ColumnWidths property to
0";1"
Set the Bound Column to the [EmployeeID] column.
Set the Control Source to whatever table field you wish to store the
EmployeeID value.

Change the table and field names as necessary.
 
Back
Top