Cascading Comboxes

[Peter]

Hi all,

I created a data entry form with a “Cascading Combobox†according to Mr.
Steels earlier recommendations. Below works perfect when entering data

Combobox 1 holds this code in the after update event.
Combobox 2 “receives†the values from selected tbls DiffColors/Metric and
NonMetric.

Select Case 1.Value

Select Case 1.Value
Case "Colors"
Me.2.RowSource = "DiffColors"
Case "Size1"
Me.2.RowSource = "Metric"
Case "Size2"
Me.2.RowSource = "NonMetric"
End Select

In my Data Edit form I have the same code/event for Combobox 1
But how/were do I code if I only want to edit Combobox 2?

If Me.1 = Colors Then
Select Me.2.Rowsource = “DiffColors†????? This does not function well..

Thanks for your patience"

 

[Jeanette Cunningham]

The problem is that when the form opens at a record for edit, the after
update for combobox 1 doesn't fire.
You can use the Current event to set the row source for combo 2.

Put code in the current event to tell combobox 2 what its row source is,
adapt the code below to suit.

Select Case 1.Value

Select Case 1.Value
Case "Colors"
Me.2.RowSource = "DiffColors"
Case "Size1"
Me.2.RowSource = "Metric"
Case "Size2"
Me.2.RowSource = "NonMetric"
End Select


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Peter]

Thank you a million times Ms. Cunningham! This works perfect!