I have been told that all forms should be based on a query even if you are using all of the fields and not using any criteria. I would like to know what the advantages & disadvantages of this are. Could someone please explain this to me?
If you are using the data from only one table then a query is not required.
Generally, a form would be using data from more than one table, in which case a query is usually the easiest way to get the data onto the form.