DropDown Box

[ProteanBeing]

I have a Data Access Page that displays a query. One of the fields is named Order Type, another is Last Operation. I want to create a DropDown box for Last Operation that loads the list specific to Order Type (stored in another table) for that record. How do I do that?

[OTWarrior]

2 ideas come to mind:
1) on load, check the order type value and change the row source for the dropdown (it is often sql based)

2) have multiple dropdowns (all not visible) and make the correct one visible based on the record value on load.

[Trevor]

I agree with OtWarrior I think the first option is the cleanest