I have a form that uses a query as it's recordsource to display data from two primary tables and one relation table. I created a delete command button using the button wizard. When I click delete it only deletes the record from the relation table 'tblLeasedUnit' and not from either primary table. The delete button will not allow me to execute a query based on more than one table.
I created two separate delete querys linked them to the delete command button. But, when my form initially opens it locks the record according to the recordsource and my custom querys are not allowed to delete it. So I tried putting 'me.recordlocks = false' in my code before my 'docmd.openquery' statements (which I thought may not be a good idea) but it doesn't appear to unlock the record for delete either. Any suggestions? Thx all!