Form based on Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you have a Form based on a Query? I need to be able to have lookup
fields on the form. What is the best approach?
Thanks!
 
Yes, forms can be based on queries. In fact, I never base them on anything
else.
 
What if I need Lookup Fields in the Form. Do they need to come from a Query
or can they come from a Table with just the lookup info in it?
Thanks!
 
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.
 
What if I need Lookup Fields in the Form. Do they need to come from a Query
or can they come from a Table with just the lookup info in it?
Thanks!
Click to expand...

There is NO SUCH THING as a "lookup field".

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

http://www.mvps.org/access/lookupfields.htm

for a critique of this feature.


John W. Vinson[MVP]
 
Back
Top