Changing which form loads in a subform

[GregoryWest]

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

 

[Dreamweaver]

I have a example that I'm working on that covers all this including dealing with master/child problems It's not finished but think I'll upload it tomorrow and add to it as needed.

 

[GregoryWest]

Going through the file, I am trying to find where you created txtRollLinkID. Can not seem to find it on the subform at all.

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

 

[bastanu]

open the subforms in design view and you'll see them -they are hidden and have a pinkish background.

 

[bastanu]

Here it is.