Updating ms access from a form
When I change the company name, it does not change in the table.
I'm not sure why it isn't updating, can anyone help me?
To remove all the records from a table, use the DELETE statement and specify which table or tables from which you want to delete all the records.
There are several ways of creating a form in an Access desktop database and this article points you to some of the common ways.
To create a form from a table or query in your database, in the Navigation Pane, click the table or query that contains the data for your form, and on the Create tab, click Form.
The following INSERT INTO statement inserts all the values in the Customer ID, Last Name, and First Name fields from the tbl Old Customers table into the corresponding fields in the tbl Customers table.
To modify the data that is currently in a table, you use the UPDATE statement, which is commonly referred to as an update query.