Syntax error due to an apostrophe in string ?

Hello everyone. I am currrently working on a project which has me mostly debugging code. I have a user-form that allows
a user to select from a drop down list a "terminal" (which by-the-way is a list of names of various physical plant facilities:
e.g. St. John's). After selecting from the drop-down list and after entering other data the user will then press a button called "Save Volumes".
There is a problem however when a user selects a terminal name that has an apostrophe in it, for instance St. John's, it causes the following error:

"Syntax error (missing operator) in query expression ...."

Now just so you know the actual list of terminal name is stored in a Access database, the 1997 version. Below is the code in question
with an error pointing to the error. Any help is appreciated.

The "Save Volumes" button code is below:

Please Login or Register  to view this content.

I suspect you need to replace the ' with a ''

Please Login or Register  to view this content.

edit: seems you have done this already re: Product so the above might be moot.

No, I was suggesting you add what I then realised you already had in place...

Please Login or Register  to view this content.

is correct

If however we're referring here to Terminal rather than Product then you should ape the above for Terminal also.

No, I am suggesting:

Please Login or Register  to view this content.

ie encase both Terminal & Product within a Replace [and maybe even SalesOrgToUseForSave if that too can contain apostrophe's]

You would need to do likewise in your UPDATE statement.

edit: the point is I am assuming Terminal.Text contains St.John's ... you've not specified that as yet (as far as I can tell)