DELETE tblpublicrecordslog.VisReqNum, tblpublicrecordslog.RequestNumber, tblpublicrecordslog.FYDateRX, tblpublicrecordslog.dbreqlogid, tblpublicrecordstimesheet.dbreqlogid
FROM tblpublicrecordslog LEFT JOIN tblpublicrecordstimesheet ON tblpublicrecordslog.[dbreqlogid] = tblpublicrecordstimesheet.[dbreqlogid]
WHERE (((tblpublicrecordslog.dbreqlogid)=[Forms]![frmrequestfinder]![dbreqlogid]) AND ((tblpublicrecordstimesheet.dbreqlogid) Is Null));
/QUOTE]
tblpublicrecordslog contains data for public records. tblpublicrecordstimesheet contains time spent for that record. If there are no records for dbreqlogid in the tblpublicrecordstimesheet The user will be given the option to delete it. I am getting Delete the table where you want to delete from message. Can someone help? Thanks.