Can't delete record in subform

  • Thread starter Thread starter yanto
  • Start date Start date
Y

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
 
yanto said:
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
Click to expand...

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?
 
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

Rick said:
yanto said:
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
Click to expand...

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?
Click to expand...
 
Back
Top