Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Delete both pages in a record

Delete both pages in a record

Delete both pages in a record

I have another challenge for you (Thanks to Paul Bent for helping me out of an earlier hole!).

My tracking project database consists of two joined databases each holding different types of information about a record. Each Project is registered on a form that spreads over two pages and incorporates information taken from both databases. I created a delete macro on page 1, which brings up a customised warning, before deleting (in theory) the entire record. However, I have found that all it does is delete the information on page one. When I go into worksheet view, the details on page 2 still exist as a record. I have not found any way of ensuring that the entire record is wiped. Can anyone help? Thanks.

RE: Delete both pages in a record

Each form has a main table. When you delete a record it deletes it only from the main table. Related record(s) in joined tables aren't automatically deleted.

In the Join dialog you can select the join line, click Options and specify that when a record in one table is deleted, matching records in the other table are deleted too. Does this fix it?

Paul Bent
Northwind IT Systems

RE: Delete both pages in a record

I think this fixes it. You've come to the rescue once again - what a STAR!

A simple fix, but one I'd been tearing my hair out over.

Thanks loads...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close