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

S

Squik27

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?
 

Ask a Question

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.

Ask a Question

Similar Threads

Can I save a sql statement generated by a search form? 1
Form question: Simplest way to bring in a query result that is notthe record source into a form? 3
Query refer to field on current open form 0
Access 2007 corrupts record source SQL string 5
Form based on crosstab query 1
Dates in a form for filtering Report query 4
Getting Around VBA Not Resolving Query Refs To Forms? 8
REPORT / QUERY - sort order question 3

Top