For all responses, Thank you. However after pulling my hair out for a few more days I finally found a solution to my own problem: Use a combo DELETE and INSERT in place of UPDATE. I did get this to work. And for anyone else who may be interested, the code is:
'Perform an UPDATE by first...
VB is telling me that my field names inside tblClients, such as ClientID are undefined. All I want to do is update a selected record that was loaded into a series of textboxes.
statement = "UPDATE tblClients " & _
"SET (" & _
ClientID = "'" &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.