Okay - another question for you. I have a form set up to schedule appointments in 5 "lanes". Each lane has a drop down list to select a client for that specific lane.

L1 Client drop down list
L2 "
L3 "
L4 "
L5 "

Occasionally we have "clinics" which would tie up all lanes and I have set up a generic client name - Clinic so if there is a clinic scheduled I just pick that from the clients list.

Is it possible that if I select "clinic" from the drop down list in L1 that lanes 2-5 will automatically populate with clinic as well, rather than having to pick "clinic" for each lane? Any time thaere is a clinic all lanes will be clinic - there will be no actual clients.

Clear as mud? Is this possible?

Thanks
Terry

Sure, not a problem.

On the OnChange event of the combo box L1 put this code (if the combos are set to return the string "clinic" or client name as the bound column:

If L1.Value = "clinic" Then
L2.Value = "clinic"
L3.Value = "clinic"
L4.Value = "clinic"
L5.Value = "clinic"
End If

BL
hth