Form Recordsource on Query

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;

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Doctor" wrote in message
...
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?