Form Recordsource on Query

  • Thread starter Thread starter Doctor
  • Start date Start date
D

Doctor

Are there any performance issues when a form is based on a query as to
whether the recordsource for the form is a store query or if the recordsource
is an SQL statement?

Does it matter?
 
No difference.

When you use a SQL statement in the RecordSource property of a form or the
RowSource of a combo/listbox, Access creates a hidden query anyway, so the
result is the same.

To see the hidden queries:
SELECT MsysObjects.Name
FROM MsysObjects
WHERE MsysObjects.Type = 5
ORDER BY MsysObjects.Name;
 
Back
Top