Re: delete record in a main form and any link records in the subfo



"hngo" <hngo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7B0D7B0E-7C53-49B3-B66A-9C47173DFC5E@xxxxxxxxxxxxx
> SORRY
>
> WHAT DO I HAVE TO DO? REPACE ALL MY CODE WITH YOURS?

Please don't shout.

Assuming you didn't mean to be shouting, I need to find out what you
really want to do. Did you consider taking the first approach I
suggested -- using cascading deletes to automatically delete all related
records when you delete the main record? That would eliminate the need
for any code at all.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.



Relevant Pages

  • Re: why i SHOUT!
    ... I love SHOUTING. ... i SHOUT because i am so excited for all of you who are ... | quitting smoking is the MOST difficult addiction i have ever had to deal ... Prev by Date: ...
    (alt.support.stop-smoking)
  • Who to shout for?
    ... The ashes has made me think of this strange phenomonon of who to shout for ... I'm Irish yet find myself shouting for England in Cricket and Football but ... shout for Australia over NZ, NZ over France, Wales over Scotland. ... I found myself shouting for Aus in the 03 RWC ...
    (rec.sport.rugby.union)
  • Re: Singing v.shouting
    ... What technically is the difference between singing and shouting, ... as voice production goes? ... most shout. ...
    (rec.music.classical)
  • Re: Cell Phones on Deck!
    ... transmitting sound to the person that's being called, ... You can't go deaf by shouting into a phone. ... People shout because they don't know any better and because ... Cell phones can be heard to hear due to their mediocre frequency responce, ...
    (rec.travel.cruises)
  • Classic mistakes -- Re: forrtl: severe (174): SIGSEGV due to output file.
    ... The usual punchline has the doctor saying "DON'T DO THAT" ... Mismatched subroutine declarations and invocations are ... While it is possible not to shout in response, ... The actual level of shouting that has been directed toward ...
    (comp.lang.fortran)