GregoryWest
Registered User.
- Local time
- Today, 07:16
- Joined
- Apr 13, 2014
- Messages
- 161
Many Many hugz, back pats, high fives. That works perfectly! I did comment back in the code you commented out. All it does is keeps updating the DB field RolllinkID on the control table. Something the user wanted, sigh.
Hi Gregory,
Can you please try the attached file and see if it works as you intended? I have decompiled the one you uploaded (I commented out some of the code in modules, you might be able to put it back as might not impact the functionality) and after a few tries I think the issue was with the linking fields. I added some hidden controls to both the main form and the subforms (txtRollLinkID) and used those in the linking and seems to work for me. Found a problem in the control table (which is a restricted word and shouldn't be used)for the RollLinkID field - had the field size 255 but Format "15" - I think you typed the field size in the format row instead...
Cheers,
Vlad