Using tables in forms/subforms.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

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
 
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.
 
Thanks, I'll do this.


Reggie said:
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.
Click to expand...
 
Back
Top