delete record from subform

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

Sorry if there is an answer out there already I
cannot 'search' in a reasonable amount of time (takes at
least a full 3 minutes to move to next page).

Form and subform sends data to same table, subform was
created because many records will have the same data over
and over and I wanted to spare the data entry people. The
problem is that when I delete a record from the subform
the fields on the main form are not deleted leaving the
data in the table. I know how to enforce referential
integrity between two tables but I don't know how to do it
when there is only one table, or even if it can be done.
any insight is greatly appreciated as always....
 
Thanks for the suggestion to use google....and of course I
am an idiot I was thinking that the child/master link
would allow me to 'link' the data on the forms....have
since separated the data via another table and enforced
referential integrity like I knew it should be, thanks for
the insight....
-----Original Message-----
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete record error form / subform 1
Could not update, currently locked by another session on this mach 3
Subform with no records 8
Records in form and subform 1
Using form and subform not connecting to two separate tables 0
Unremovable horizontal scroll bar on subform 1
link subform to other form 4
Trouble associating parent form record to subform's record 1

Back
Top