O
Opal
Help! I can't see where my error is....
I am running Access 2003 and have the
following:
Dim strQuery As String
Dim HoldAreaID As Integer
HoldAreaID = Forms!frmProcessUpt!AreaID
strQuery = "UPDATE Processtbl " & _
"SET AreaID = " & HoldAreaID & _
"WHERE AreaID Is Null"
CurrentDb.Execute strQuery, dbFailOnError
I keep getting a runtime error 3075 missing operator
Can someone help point me to where I went wrong?
I am running Access 2003 and have the
following:
Dim strQuery As String
Dim HoldAreaID As Integer
HoldAreaID = Forms!frmProcessUpt!AreaID
strQuery = "UPDATE Processtbl " & _
"SET AreaID = " & HoldAreaID & _
"WHERE AreaID Is Null"
CurrentDb.Execute strQuery, dbFailOnError
I keep getting a runtime error 3075 missing operator
Can someone help point me to where I went wrong?