We have been trying to correct the code in this Access 2003 form without success and continue to have a syntax error.
Any assistance will be appreciated.
Thank you
Marylyn
We have been trying to correct the code in this Access 2003 form without success and continue to have a syntax error.
Any assistance will be appreciated.
Thank you
Marylyn
Couple of problems:
Your concatenation needs a space "update Investments01_tbl " & _Code:CurrentDb.Execute "update Investments01_tbl" & _ "set investigate = 'No' " & _ "where Investmentl_ID in (SELECT Investmentl_ID from (" & Replace$(Me.RecordSource, ";", "") & "));"
The other problem is the form in which the code resides has no recordsource.
Cross-posted: https://www.access-programmers.co.uk/forums/threads/syntax-error-in-changing-a-fields-contents.329772/
Please read: https://excelguru.ca/a-message-to-forum-cross-posters/
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Bob,Cross-posted: https://www.access-programmers.co.uk/forums/threads/syntax-error-in-changing-a-fields-contents.329772/
Please read: https://excelguru.ca/a-message-to-forum-cross-posters/
If I recall, this is a username that is used by everyone in the company, so you are talking to different people all the time?
The username over at AWF is Access2010. Here is states they are using Windows 10 and 2007, and in the post they say 2003?
In fact one of the questions over in AWF is to be able to upgrade from 2003 to 2007?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba