VBA Delete record

[tylerg11]

Hi,



I need to delete records from a table using SQL within VBA such as the following.

CurrentDB.Execute "DELETE FROM dbo_LeadNote WHERE CompanyCode = " & Me.CompanyCode

My problem is that I have linked tables from two different databases. So rather than using CurrentDB what should I use to specify the database?

[pbaldy]

If the tables are linked it wouldn't matter. It will delete from the linked table named "dbo_LeadNote" regardless of where that table actually resides (or what its actual name is).