another way aside from ODBC

[AccessKid]

I have a form that needs to have an SQL table as its recordsource. Is there a better way to connect the form to the table without using ODBC? I have tried the ODBC approach but it seems that the form's data manipulation response time is too slow. Or it is just wishful thinking on my part to assume that ADO or another method of doing this will speed up the response time a little bit?

Thanks.

 

[AccessKid]

Hi Pat:

Thanks.

This means I have to modify my form to allow a search before any record is displayed. I'm not sure if I saw this in Access before but is it possible to display the form without any record being displayed until a search is made by the user?

Second question: will those forms with combo boxes that get their item data from an ODBC table also not advisable? What are my choices for those combo's?

 

[AccessKid]

Thanks for the tips, Pat.