Run Time Error 3075 in Access 2007

[claskew]

Hi,

I am in serious need of some help. I have been trying how to fix the code in access and I am coming up with no resolution. I am new to this, so any help will greatly be appreciated.

Private Sub UpdatePubName()
' UPDATE RECORD FOR Tbl_PubName
' execute sql to update record in Tbl_PubName using form data
' PubName, Spanish, PubType
Dim UpdatePubNameSQL As String
UpdatePubNameSQL = "UPDATE Tbl_PubName SET " & _
"PubName = '" & Replace("TextPubName", "'", "''") & "', " & _
"Spanish = '" & CheckSpanish & ", " & _
"PubType = '" & ComboPubType & "' " & _
"WHERE PK_pubData = " & LkpPK_PubData & ";"
CurrentDb.Execute UpdatePubNameSQL

The CurrentDb.Execute UpdatePubNameSQL is highlighted.

 

[PHV]

And what is the exact error message ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[claskew]

PHV,

I corrected it, but I really don't know how...I couldn't tell you what I did.

I do appreciate you helping me with this. I like this site. I am sure I will have something very simple on here tomorrow. Look out for me.

Thanks again.