I have literally been working on this for hours and can't for the life of me figure out what the issue is. Everything works fine except for some reason the part in Bold gives me the Too Few Parameters Expected 1:
Set CustNums = CurrentDb.OpenRecordset("SELECT CT.[Cust Num]" & _
"FROM ([Customer Table] AS CT INNER JOIN CSMST AS CS ON CT.[Cust Num] = CS.[CSCUST]) INNER JOIN [Group Members Table] AS GMT ON CT.[CT ID Num] = GMT.[CT ID Num] " & _
"WHERE ((ct.[Cust Num]) Is Not Null) And ((CS.CSWEB) <> Y) And ((GMT.GroupIDNum) = " & [Forms]![Use Customer for Bid Form]![GroupIDNum] & ") " & _
"ORDER BY CT.[Cust Num]")
Is there a specific way I have to write in VBA to <> (not equal something)? Because in a regular query on Access I just put in <> "N" for example and it searches for anything without an N in that column.
Any help would be appreciated I know this is a topic that is brought up multiple times after surfing the internet looking for an answer.