I advocate basing forms on queries because
- I can test the query before wasting my time on a form that won't work
- I can easily filter the query rather than using form properties to filter. I have never been able to find out if a form filter a) reprocesses the recordset or b) pulls in the entire set but only shows you what the filter allows. Either way, I see those options as being less efficient than loading a form with a query whose records have already been filtered.
- I can easily sort the query
- I can include more than one table (mostly for when the form isn't for editing). There is a widespread notion of 1 form per table/query.
Why you did one or the other isn't that important, but could have been due to your own development if the query one came later.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.