strive4peace wrote in
:

I like to use tables for RecordSource if the data is stored in
Access and it is not necessary to filter the records or calculate
anything

I think this is bad advice. For instance, if you base a combo box on
a table, and then replicate the back end, you'll end up seeing the
replication fields in your combo box, because Jet replication
inserts the replication tracking fields at the top of your table
design.

Secondly, if your combo box is based on a table with more fields
than you want to display, you have to set a bunch of colum widths to
0 just to keep them from displaying. If you use a SQL statement, you
retrieve only the fields that are needed.

I would say that in all cases, SQL statements (or the name of a
saved query) is superior, and would recommend against every using a
plain table name as rowsource or recordsource.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/