Using tables in forms/subforms.

[Frank Martin]

I have to redesign an invoice form containing a subform call "InvoiceLines."

Is best to use the table "Invoice Lines" for this subform, or is it better
practice to use a query of the table "Invoice Lines"?

Please help, Frank

 

[Reggie]

Frank, It's normally more flexible basing forms/subforms on queries. Much
easier to set default sorting to setup criteria/parameters for the data you
want displayed on your forms. You can also add multiple related tables to
the query to include in your forms.

 

[Frank Martin]

Thanks, I'll do this.

Frank, It's normally more flexible basing forms/subforms on queries. Much
easier to set default sorting to setup criteria/parameters for the data you
want displayed on your forms. You can also add multiple related tables to
the query to include in your forms.