Syntax for selection criteria used by a query (1 Viewer)

Morning guys

I have a routine that sends scheduled emails.
It runs down a list of records (Myrec1) and runs those that need to be run. A parameter is set for selection criteria in a query.

Some emails then have a sub routine loop (Myrec2) that then sends personalised emails to selected people rather than a generic email.

I have two issues
1) Testing the sub loop using a fixed field name (Owner) to send to owners but I cannot get the right syntax for the quotation marks "
GBL_stLinkCriteria = "'Owner = '" & myrec2![Owner] & "''"
Can anyone help with the syntax?:banghead:

Secondly:
2) I want to pick up the name of the field as a variable from the sub routine data (myrec2) so that the Owner (above) field can be a variable - something like . . . .
GBL_stLinkCriteria - "'" & myrec1![stLinkCriteria] & " = '[" & myrec2![VariableName] & "]'"
Again can anyone help with the syntax?:banghead:

Exactly how are you using GBL_stLinkCriteria? Post procedure.

I am calling a module with this code in it

DoCmd.OpenReport GBL_StDocName, acViewReport, , GBL_stLinkCriteria, acNormal

DoCmd.SendObject acReport, GBL_StDocName, acFormatPDF, GBL_MailTo, GBL_MailCC, GBL_MailBcc, GBL_Subject, GBL_MailGreeting & GBL_MailMessage & GBL_MailSignature, True

Hmm, not going to work that way. Perhaps this will help...
https://www.access-diva.com/vba16.html

Correct syntax:

GBL_stLinkCriteria = "[Owner] = '" & myrec2![Owner] & "'"

or:
GBL_stLinkCriteria = "Owner = '" & myrec2("Owner") & "'"

Field name goes on left and filter parameter on the right.

Brackets [] define object names and are needed if names have spaces or special characters or are reserved words. Apostrophes delimit parameters if field is text type.

As for part 2, not sure what goal is. Why would field name need to be variable? How is stLinkCriteria set?