Hi guys ...major problem I would like to question the community on!

I have a app that connects to a MS Access97 database. I believing I'm using ADO to do this. I have a form that has a tab control on it and the form is poulated with about 40 feilds. I have about 10 adodc controls that are hooked to 10 dbCombo boxes. I have a lot of validation occuring as the user moves from record to record. There only about 50 - 100 records been pulled back again using a ADODC control.

The problem is it takes about 3sec to move from record to record. I load all my combo boxes as the form loads therefor its not trying to load the combo boxes all the time. The validation is basically making certain controls and text boxes invisible depanding on the value in certain combo boxes. Is there a better stategy to speed things up?????


Regards


Gerard