munkeyroot
Registered User.
- Local time
- Today, 02:28
- Joined
- Jan 13, 2011
- Messages
- 76
Hi Everyone
just wondered if anyone has come across this before.
i have a main form with sub forms and trying to duplicate them.
so method (in my madness) is to:
first use the duplicate macro on a command button for main form (as this gives me the first ID) - if tried this and works ok. this gives me the data from the main form - however not subforms.
Now the tricky part for the sub forms:
i was going to do this in the same way as the main form using the duplicate macro, however it would not know what the Main_ID is,
(in the tables i do have Subform_ID PK, Main_ID),
so i would need to tell the duplicate macro what ID to go to.
this is the bit i'm not sure on.
the macro would need to "select all records" on the table not just the one the cursor is in.
hope anyone can help or if i am on the right or wrong track
cheers munk
just wondered if anyone has come across this before.
i have a main form with sub forms and trying to duplicate them.
so method (in my madness) is to:
first use the duplicate macro on a command button for main form (as this gives me the first ID) - if tried this and works ok. this gives me the data from the main form - however not subforms.
Now the tricky part for the sub forms:
i was going to do this in the same way as the main form using the duplicate macro, however it would not know what the Main_ID is,
(in the tables i do have Subform_ID PK, Main_ID),
so i would need to tell the duplicate macro what ID to go to.
this is the bit i'm not sure on.
the macro would need to "select all records" on the table not just the one the cursor is in.
hope anyone can help or if i am on the right or wrong track
cheers munk