How to link combo boxes with multiple records?

[Guest]

I know how to link combo boxes on a form (first combo box limiting selection
in combo box 2) but having problems doing it with a tabular form where there
are multiple records displayed under the related fields.
I am using a ServiceProvider field and a ServiceType field and need to
display multiple records on the form.
Think I somehow need to base each ServiceType record on its corresponding
ServiceProvider record.
Any suggestions welcome.

 

[Guest]

I know how to link combo boxes on a form (first combo box limiting selection
in combo box 2) but having problems doing it with a tabular form where there
are multiple records displayed under the related fields.
I am using a ServiceProvider field and a ServiceType field and need to
display multiple records on the form.
Think I somehow need to base each ServiceType record on its corresponding
ServiceProvider record.
Any suggestions welcome.

 

[Guest]

Danno,
If you are using a tabular form, you will need to refresh the filtered combo
in the selected row each time you change row, depending on which Service
Provider is currently selected. Are you familiar with VBA? If so, you can do
this in code using the OnCurrent event for the form.
I would suggest writing a separate Sub that applies the filtering query to
the second combo, and calling that on the OnCurrent event and also on the
change or click events of the first combo.

 

[Guest]

Danspanker,
Thanks for reply. Will give it a go.