Can't delete record in subform

[yanto]

Hi All,
I have one form that has 2 subform A & B ( as master/detail), there is
ProductID field in master side (main form) as link to subform A as
detail, this subform also act as master with ID field as link to
subform B as detail.
So prroperties on subform B:
Link Child Fields: ID
Link Master Fields : [frmSubWOs].form!ID
The problem is when I delete any record on subform A, the computer
hang.but when I remove subform B from my form, I can delete.
the relationship between these 2 table/subform are cascade update &
delete.
Any idea to solve this problem?
TIA
Yanto

 

[Rick Brandt]

Hi All,
I have one form that has 2 subform A & B ( as master/detail), there is
ProductID field in master side (main form) as link to subform A as
detail, this subform also act as master with ID field as link to
subform B as detail.
So prroperties on subform B:
Link Child Fields: ID
Link Master Fields : [frmSubWOs].form!ID
The problem is when I delete any record on subform A, the computer
hang.but when I remove subform B from my form, I can delete.
the relationship between these 2 table/subform are cascade update &
delete.
Any idea to solve this problem?
TIA
Yanto

I have only used that setup once or twice, but do not recall having any problems
with it. How do you have record locking set for all of the forms?

 

[yanto]

Thanks for response Rick,
I am using Edited Record Locking.
If you wish I can send my sample mdb-file to youur private email.
Best Regard
Yanto

Hi All,
I have one form that has 2 subform A & B ( as master/detail), there is
ProductID field in master side (main form) as link to subform A as
detail, this subform also act as master with ID field as link to
subform B as detail.
So prroperties on subform B:
Link Child Fields: ID
Link Master Fields : [frmSubWOs].form!ID
The problem is when I delete any record on subform A, the computer
hang.but when I remove subform B from my form, I can delete.
the relationship between these 2 table/subform are cascade update &
delete.
Any idea to solve this problem?
TIA
Yanto

I have only used that setup once or twice, but do not recall having any problems
with it. How do you have record locking set for all of the forms?