[AccessD] RunCommand acCmdDeleteRecord deleted data in from JOINed tables?
wrwehler at gmail.com
Tue Sep 21 16:10:48 CDT 2021
Yes that’s basically the solution I’ve come up with as well.
Thanks for confirmation that I’m not the only one.
Sent from my iPhone
> On Sep 21, 2021, at 3:37 PM, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:
> I had a similar situation bite me recently.
> A form based on a multiple table query.
> Deleting a record by selecting it and hitting "Delete" on the keyboard deleted related
> I ended up making the form "AllowDeletions" = False and displaying a Delete button with
> code behind it to do:
> CurrentDB.Execute"Delete * from tblPrimryName whenre PrimaryTablePK - " &
>> On 21 Sep 2021 at 12:12, Ryan W wrote:
>> I have a form, Checklist, it's RecordSource WAS WorkOrderChecklist.
>> I then attempted to join WorkOrderCheckList with WorkOrder for the
>> datasource to get data about the workorder to display on the Checklist
>> the ribbon has a button "delete"0 that calls a function and sets the
>> form / control in focus and runs:
>> DoCmd.RunCommand acCmdSelectRecord
>> DoCmd.RunCommand acCmdDeleteRecord
>> In doing so, not only is the data in WorkOrderChecklist gone but the
>> WorkOrder table itself (OOPS).
>> Is this expected behavior? I might have to tweak my delete button in
>> the ribbon to target the table instead of the selected record if
>> that's the case.
>> I found this blog post that more or less illustrates a similar issue:
>> Record---unintended-problems.html -- AccessD mailing list
>> AccessD at databaseadvisors.com
>> https://databaseadvisors.com/mailman/listinfo/accessd Website:
> AccessD mailing list
> AccessD at databaseadvisors.com
> Website: http://www.databaseadvisors.com
More information about the AccessD