Avatar

Level 10

This is pure speculation without seeing the database structure or the form. Are the values that populate the DDlists in different tables or the same one? If they are in different tables then I think you  will need a different data connection per table. If they are the same then you shodul be able to define the SQL statement that you want to run in the current code.

Lastly which event are you using to run the second query? I suggest that you use the exit event of the DDList and not the change event.

Paul