Comma woes

[Niniel]

Forms!frmRSC!sfrmRSCDisclosures1!Speaker.RowSource = "SELECT tblDisclosures.DisclosureID, tblSpeakers!SPNameLast & ", " & tblSpeakers!SpNameFirst AS SPNames FROM tblSpeakers RIGHT JOIN tblDisclosures ON tblSpeakers.SpeakerID = tblDisclosures.SpeakerID;"

The comma in the expression SPNames is creating a problem - I am getting an "expected end of statement" error.
What do I need to do to make this work?

Thank you.

 

[RuralGuy]

Try:
Forms!frmRSC!sfrmRSCDisclosures1!Speaker.RowSource = "SELECT tblDisclosures.DisclosureID, tblSpeakers!SPNameLast & ', ' & tblSpeakers!SpNameFirst AS SPNames FROM tblSpeakers RIGHT JOIN tblDisclosures ON tblSpeakers.SpeakerID = tblDisclosures.SpeakerID;"

 

[Niniel]

No error, but now I see only the last name in the combo box, not "last name, first name".

 

[pbaldy]

Single quotes around the comma.

 

[Niniel]

That's it!

Thank you!!!