unbound form SQL query question

[hooks]

I have a unbound form with unlinked tables ADO.

My question is about sql and combo boxes.

Which is better

Using a table as the source of the table
rs.Open ("SELECT * FROM tCustomers)

Or using a stored query off of the same table
rs.Open ("SELECT * FROM qCustomers)

I would assume that using the table as the query source would be faster. Although after reading a whole lot in this forum I gather that queries are faster and save the database some size.

How would i do the equivilent of

Dim db AS DAO.Database
Dim rs AS DAO.Recordset
Set db = CurrentDB
Set rs = db.OpenRecordset("qCustomer")

in ADO with unlinked tables

Thanks

 

[hooks]

I don't understand how bound forms would be more efficienct then unbound forms. I am in the process a creating a rather large (for me anyway) database for a lumber company that will have 7 users logged in at once. There will not be a whole lot of traffic so i figured access would handle it. I am just trying to be as perfect as it can be.

 

[hooks]

Thanks Pat.

That makes a lot of sense
So Pat do you always use bound controls?
What version of Access do you use?