Form Practices

[dbprogman]

is it a good practice to build a form from a query (bringing together all tables for one form) or is best to create a form directly from the table(s) using subforms?

Thanx 4 ya thoughts...

My old man always said "Don't tell 'em son show 'em"

 

[Smart]

It depends on the circumstances but as a rule of thumb I believe it is best to base the form on a query.
If you use a query you can manipulate the data in the query and then use the info on the form

 

[Pat Hartman]

This is not an either/or question. Forms should be based on queries because that allows you to join to lookup tables, provide criteria, provide an order by clause, etc. If you have a 1-many relationship, a main form with a subform would be the best solution for managing the data but BOTH forms should be based on a query.

 

[dbprogman]

Form query

Thanks for your replies this has confirmed what I suspected to be correct

Thankyou