×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

Form/Subform. How to to duplicate record as new, with blank key field.

Form/Subform. How to to duplicate record as new, with blank key field.

Form/Subform. How to to duplicate record as new, with blank key field.

(OP)
I have created a form with subform. What I need to do is duplicate the current record, creating an identical new record with a blank key field. I have tried many different ways to get it to perform the required function but with no success.  Any solution would be gratefully accepted  i.e. macro, code or SQL.

This is probably something very simple, but with limited knowledge it is proving to be a nightmare.

Thanks

Jim

RE: Form/Subform. How to to duplicate record as new, with blank key field.

Jim, I would need some more info to continue with this. With a form and subform, there are usually two tables involved. Do you need the main form record duplicated or do you need the subform record duplicated? Also, what would you do with the record if it has no key id?

John A. Gilman
gms@uslink.net

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