R
Ron Weaver
Occasionally while entering an order on my Orders form/OrderDetails subform
I need to delete the current record. I thought my delete command would
delete the record from the form and both tables. The record is deleted from
the form, but not from the tables. My tables are set to cascade on delete.
Currently to delete a record from the tables, I first have to close the
Orders form, go to my search form, and reopen this record in the Orders form.
The delete command then deletes the record from both tables. I have tried
using 'Me.Refresh' as the first line of code in my delete code, with no
results.
Thanks for any help on this.
I need to delete the current record. I thought my delete command would
delete the record from the form and both tables. The record is deleted from
the form, but not from the tables. My tables are set to cascade on delete.
Currently to delete a record from the tables, I first have to close the
Orders form, go to my search form, and reopen this record in the Orders form.
The delete command then deletes the record from both tables. I have tried
using 'Me.Refresh' as the first line of code in my delete code, with no
results.
Thanks for any help on this.