Cbo: query or table?

M

Michael Wong

I have a cbo on my form that fills with data from a simple query:

QContact:
- ContactName (Ordered)
- Address
- Phone

that queries from a table:
TContact:
- ContactName
- Address
- Phone

I wondering that is it worth doing a query from a so simple table to fill up
the cbo?
 
M

Marshall Barton

Michael said:
I have a cbo on my form that fills with data from a simple query:

QContact:
- ContactName (Ordered)
- Address
- Phone

that queries from a table:
TContact:
- ContactName
- Address
- Phone

I wondering that is it worth doing a query from a so simple table to fill up
the cbo?
Click to expand...

I think it's always worth it, if for no other reason than to
sort the list of items (tables are NOT ordered). Besides,
any speed penalty is usually too little to notice, so its a
small price in any case.

It is not necessary to create a saved query just for one
combo box. You could place the query's SQL directly in the
RowSource property.
 
Top