Update statement on a form??

Hi all,

Is there any way I can execute an update statement on a form using SQL?

Thanks.

Rgds,
Tracy

u can create a command button on your form using the wizard and attach your SQL query to it. miscellaneous - run query.
it worked for me.hope this helps u.

Yes and No SQl is used to update a table not a form, but you can run an SQL statement from code within your form

The best way to learn more about SQl, to use the Query Editor in Access. Create the query to do what you want, and look at the SQl code(SQL View) that it generates and copy and paste it into your VBA Code.

S-