Improving performance of an adp (1 Viewer)

I've just about finished converting an access 2003 database to an adp based on sql server 2000. One of the big problems remaining is that I've got a couple of forms that are taking too long to load up. I'm just looking for suggestions on how I can improve on this. One form takes 30 secs to open the other about 45 - 1 minute.

One of the forms consists of a main form based on a stored procedure that returns 1 record. I run the sproc and enter the 2 parameters and the results come back immediately.

The subform is based on a sproc as well. I run this and enter the 1 param and that too returns the values immediately.

I should mention the subform has got quite a few combo boxes that have sql as record source.

Any ideas on how I can make this load faster?

Thanks,

Peter

Peter,

I should mention the subform has got quite a few combo boxes that have sql as record source.

You can move the LookUps for the combos to the front-end.

Or, you can look for other ways that you can avoid moving an entire table
over the Net.

Wayne