I am trying to update a table depending on the value in strwhere
The update statement does not recognise the variable.

Dim strwhere As Integer
Dim strsql As String
strwhere = oldTcp
strsql = "UPDATE TCPIP SET TCPIP.Allocated = 0 WHERE ((TCPIP.ID)=[strwhere]);"

Replace

strsql = "UPDATE TCPIP SET TCPIP.Allocated = 0 WHERE ((TCPIP.ID)=[strwhere]);"

with

strsql = "UPDATE TCPIP SET TCPIP.Allocated = 0 WHERE ((TCPIP.ID)=[" & strwhere & "]);"

The variable was earlier taken as part of the string literally

Cheers
Shasur

http://www.vbadud.blogspot.com

Thanks for your help, as the value is an integer I took the brackets out and it worked fine.

Saved me a lot of time.

Thanks again

Anne