Are you talking about the ill-conceived Lookup Field "feature"? You should
never use it. See http://www.mvps.org/access/lookupfields.htm at "The Access
Web" for a discussion of why not.
Your query should join the appropriate tables and bring back all of your
data. This is actually true even if you're using Lookup Fields.
A combo box is a tool, a way of displaying data from one table and
storing it into another table. Of course you can put a Combo Box on a
form; that combo box can be based on a table or on a query, and the
field to which it is bound can be based on a table or on a query. It
is NOT necessary to use Microsoft's misdesigned, misleading, and very
limited "Lookup Wizard" in order to do this. See
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
