Updating Values in Other Object with Code

[jwindon]

I know that I can create and run an update query to change data in a table from another object with a different recordsource, BUT

Can I do this with Code alone and NO update query? If so, PLEASE! tell me.

 

[Rich]

DoCmd.RunSQL "UPDATE Appointments SET Appointments.Mult = No;"