linking query to form/reports vs. embbeding query to forms/report

linking query to form/reports vs. embbeding query to forms/report

Post by U3F1aWsyN » Sat, 06 Jun 2009 08:56:01


hi,
I'm creating an application and I'd like an answer to the following question.
What would be better between:
1. Creating a query and set the record source of a form/report to that
query, or
2. Invoking the query builder to create a SQL statement in the record source
property.

Thank you for your answers?
 
 
 

linking query to form/reports vs. embbeding query to forms/report

Post by Chris O'C » Sat, 06 Jun 2009 09:15:38

Use a saved query as the record source so the form is bound. You won't get
the full benefits of bound forms (but you'll get some) if you replace the
name of a saved query with a SQL statement in the record source.

Chris





--
Message posted via AccessMonster.com
http://www.yqcomputer.com/