Form Recordsource on Query

[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?

 

[Allen Browne]

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;