This is especially true if there are two or more tables involved in the update process.In general data may be updatable, updatable under certain conditions, or not updatable at all.To preview the records that will be updated, click View on the toolbar.The data as it exists before the update operation will be displayed in Datasheet view.Creating the table used in the tutorial In a previous article on action queries, the Make Table query was discussed.Using the procedure discussed in the tutorial, a Test Product Qry was created using the following SQL View of the Make Table query.This immediately brings up the message window, letting you know about the changes that are going to be made.
After making entries, when you try to close the query editor, you will be asked whether you want to save and you may give a name to the query.The Table row shows the name of the table that contains the field.To see how the values will be changed, look at the expression in the Update To row.If your intention is to perform a bulk update operation, click Yes. To find out more about what this query does, click No to close this message, then open the query in Design view (in the Database window, select the query, and click Design).
To avoid being prompted when you run such queries, on the Tools menu, click Options, then click the Edit/Find tab. Then do one or more of the following: To see which fields will be updated by the query, see the names in the Field row in the design grid.Similar to the procedure used in the form, just navigate to the item, edit its content, move to another record using the navigational keys and the update becomes effective.