Why does this string keep saying "Variable not Defined?"

[Guest]

I'm afraid I can't see anything wrong with this.

MySQL = ("SELECT JusticeName FROM tblJusticenames WHERE" &
rs.Fields("JudgeId") & "=" & TblJusticeNames.JusticeID)

Thank you very much for your help.

 

[Jeff Boyce]

Joanne

Where did the "rs.Fields("JudgeID")" come from?

The SQL statement says to get the contents of the field [JusticeName] from
the table named "tblJusticenames" when the ??recordset (?what recordset)
field of [JudgeID] is somehow (don't use "=") related to field called
[JusticID] in the table "tblJusticeNames". This doesn't make much sense.

Now, what are you TRYING to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[David F Cox]

perhaps a space after WHERE ?