Left join delete

[twimms]

I have a continuous form with a command button to delete whatever record the user needs deleted. It worked perfectly until an addition to the database required me to change the record source of the form slightly (I had to add a left-join to another table). Since that time, although it appears to the user that the record is being deleted, it is not. If the user *deletes* a record and doesn't close and then reopen form, they never realize the record actually still exists. I understand why this is happening, and I understand that the easiest way around it would be to redesign the form into a form/subform layout. However, that's not the way the user wants to view the data, so I really need to stick with the current design. I know it can be done via code, but I have no idea where to start. Any help would be greatly appreciated!

Here is the current recordsource for the form:

SELECT tblContact.ContactID, tblContact.CaseInfoID, tblContact.PostedDate, tblContact.ServDate, tblContact.FaceToFace, tblContact.TeamMtg, tblContact.CrisesPC, tblContact.CC, tblContact.StaffMtg, tblContact.Admin, tblContact.DS, tblContact.DSTypeID, tblContact.OC, tblContact.OCTypeID, tblContact.NS, tblContact.Court, tblContact.Training, tblContact.Travel, tblContact.Notes, blContact.numID, tblAmendedDates.AmendID FROM tblContact LEFT JOIN tblAmendedDates ON tblContact.ContactID = tblAmendedDates.ContactID;

 

[HiTechCoach]

IMHO, unless there is a one to one relationship with tblAmendedDates it should not be in the query. The table should be displayed in a sub form.

I find that if you are having this delete issue, it is based on a record source issue. You will probably have other issues if you don't fix the issue. I would avoid work-arounds.