you are missing a comma after M_STATE:
this:
strMemberTablePrefix & "MEMBERS.M_STATE " &_
strMemberTablePrefix & "MEMBERS.M_PMRECEIVE " & _
should look like this:
strMemberTablePrefix & "MEMBERS.M_STATE, " &_
strMemberTablePrefix & "MEMBERS.M_PMRECEIVE " & _