Calling an External Database Table

[cstaab]

I have connected to a Lotus Notes database via ODBC within my code. The problem that I am having is within my SQL to query back certain records. This is the SQL that I am using:
DoCmd.RunSQL ("INSERT INTO tblMain ( City, DateCreated )
SELECT CustomerIssue.City, CustomerIssue.DateCreated
FROM CustomerIssue
WHERE (CustomerIssue.DateCreated)>= #" & DateStart & "# ")
tblMain is the table I want to place the records into within Access.
CustomerIssue is the Lotus Notes Table name.

For some reason Access doesn't recognize CustomerIssue as a valid table. What do I need to do to tell Access that the CustomerIssue is from the Database that I connected to ODBC.

Any Help is Greatly Appreciated.

Thanks