Syntax Error in changing a field’s contents

[SmallBusiness]

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

[davegri]

Couple of problems:

CurrentDb.Execute "update Investments01_tbl" & _
  "set investigate = 'No' " & _
  "where Investmentl_ID in (SELECT Investmentl_ID from (" & Replace$(Me.RecordSource, ";", "") & "));"

Your concatenation needs a space "update Investments01_tbl " & _

The other problem is the form in which the code resides has no recordsource.

[Bob Fitz]

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/

[Welshgasman]

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/

Bob,
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?