Updating a table

[ainstien]

How would I update my cash account account table through a form? I have just started working on access and am fairly new to it.

What I am trying to do is to update my master table with all the daily sales through a form. Would I need to write a query into my form?

 

[Mihail]

Use the Form Wizard to create the form.

 

[ainstien]

I created a form but I can't get it to update all my tables while being filled out. in case I want the inventory to be sold out and being shown as sold after a sale.