VBA SQL Update 1

[LizardKingSchwing]

Hi

Does anyone know how to run an update SQL query in VBA to update a Table. I build up the Update Query String and need to run it based on the CurrentDb any examples would be grrrreat

Cheers

LK--<

 

[nickjar2]

LK,

Here is what I do. I first build the SQL in the query window, and copy and paste it into a code window.

dim sSQL as string
dim db as database

set db = currentDB
sSQL = &quot;Your update statement&quot; 'You said u already have this

db.execute (sSQL)
set db = nothing
db.close

Nick

 

[LizardKingSchwing]

Cheers Nick