Hi,

I am trying to populate a combo with the following Where clause. There is something wrong with my code.

Any help appreciated.

Regards,

Alan.

SQL = "SELECT * FROM Customers ORDER bY CompanyName" & "WHERE MailDateSent Is Not Null" & "FollowUpDate Is Null"
Set Customers = DB.OpenRecordset(SQL, dbOpenDynaset)