Updating tables without using an update query

[jlocke]

I'm looking to update a field in a record without using an update query, resaon being i need to make create a run time out of the data base and i don't want the program to prompt the user that a table is being updated. any suggestions?

 

[scottfarcus]

Use DoCmd.SetWarnings(False) to turn off the warning message before you run the Update query.

Use DoCmd.SetWarnings(True) to turn them back on after you run the query.