Constructing an SQL UPDATE Command

To construct an SQL UPDATE command using the SQL Wizard:

1. From the Record Source tab of the Data Control OLE Properties dialog box, click Run SQL Wizard. The Select Operation dialog box appears.
2. In the Select Operation dialog box, click SQL Update. The Select Table to Update dialog box appears.
3. Select one or more tables for your statement, then click Next. The Select Columns to Update dialog box appears.
4. Insert values into one or more table columns for your statement.
5. Optionally, create a row filter based on selection criteria you define. Click Next. The Finish dialog box appears.
6. Optionally, edit the statement. Click OK to return to the Data Control OLE Properties dialog box.

See Also