I am writing a program for class, and it requires that we write and SQL SELECT statement. I thought I typed it in correctly, but the computer thinks otherwise. I get an error 3141 - The select statement includes a reserved word or an argument name that is either missing or mispelled, or the puncutation is incorrect. Here is what my code looks like. intCustomer is the customerid number entered earlier in program by user:

pstrFROM = " FROM tblCustomer"
pstrWHERE = " WHERE fldCustomerID = " & "'" & intCustomerNumber & "'"

psqlSelect = "SELECT" & pstrFROM & pstrWHERE
Set gdbMentorRecords = _
Module1.gdbMentor.OpenRecordset(psqlSelect)

Any help would greatly appreciated!
Thanks
Rachael