Error 3622

S

SF

Hi,

I get an error meesgae while trying to update an ODBC linked table from the
code below. The error message is error # 3622, you must use the dbSeeChange
with recordset...



Dim Stg As String
Dim db As DAO.Database

Stg = "UPDATE tblContacts SET tblContacts.Co_Province_ID =" &
Me.Co_Province_ID
Stg = Stg & ", tblContacts.Co_DistrictID =" & Me.Co_DistrictID
Stg = Stg & ", tblContacts.Co_CommuneID =" & Me.Co_CommuneID
Stg = Stg & ", tblContacts.Co_VillageID =" & Me.Co_VillageID
Stg = Stg & " WHERE (((tblContacts.Co_ContactID)=" & Me.Co_ContactID & "));"

Set db = CurrentDb

db.Execute Stg, dbFailOnError

SF
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code won't work 1
Runtime error 91 2
Excel workbook and printing 3
Code wont work 2
Help with code 2
Data entry with Leban RTF 0
Code very slow 2
Help with This Code 2

Top