Query as Record Source in Form or Report

G

Guest

Hi
Is there any difference in performance or something regarding the way I use
a query as a record source in a form or report. I mean when I describe the
query on the Record Source field of a form or report, or when I have the
query as a separate object and I call its name on the Record Source field?

Regards
GL
 
D

Douglas J. Steele

I find it simpler to have everything as queries. That way, it's possible to
use the same query as the record source for, say, a form and a report, or
more than one report.
 

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

Record number 8
Is a query a record source for any report in my db? 2
linking form to record 1
Record Source as Multiple Tables 1
Report record order 3
Cannot run Access query or report as "record is deleted" error ap. 1
Using form as criteria for report query 4
Enter Parameter Value in Report 3

Top