Update table

[jiajian]

Hi

This may be asimple question to most of you & I really need help.

How can I create a form (with sub - form) & update the data to a table?

E.g When I receive a Invoice which consist field of [Date], [Inv No],[Supplier] on the header with sub form of [Item],[Description],[Qty], [Unit Price] & [Amount] & I would likewhen I enter to this form, it will auto appear in a table.

Thanks

MH Tan

 

[Dugantrain]

To create a form and subform bound to tables using the Form Wizard, you need your data in two separate tables and to have these tables tied together with a one-to-many relationship. Write a query that captures the fields that you need out of these tables and then use the Form Wizard to create a form based off of this query. A Form based off of a Query which is based off of Tables would be a Bound Form and any changes in the data displayed in the form will automatically change the data in the tables.