Cbo: query or table?

  • Thread starter Thread starter Michael Wong
  • Start date Start date
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?
 
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.
 
Back
Top