Firstly thank you so much to these forums. They save my life so often. Hoping someone can do the same with this issue I have - its' a bit complicated!
I have a form which outlines a number of account types (Individual, Joint, Company etc) which are all individual subforms. Within the Joint and Company subforms you need to indicate how many holders / directors there are by entering a figure which in turn produces a table with that amount of rows for completion of their names. The code I used for this is in the click event of a button:
*txtCorpNum being the field you enter the number in - within a subform called sfDetail*
*form1.Main.sfCorp.tblCorpName being the subform the resulting table is contained in - which is hidden until the button is clicked*
This works wonderfully for all account types that require it - but if a person has multiple account types, they need an option to ADD another account. So I have wrapped ALL the subforms for the separate account types into ANOTHER subform called "Account" and clicking will add a new instance of ACCOUNT containing all the types to choose from again. Again all working like a charm, but the one thing I cannot get to feed through is the repeating table.
Can anyone tell me how I can reference the number to replicate in the new "Account" subform? If I choose the same account type in the new subform it adds to the original subform, not the repeated one.
Probably makes no sense but hopefully someone can help
You - my friend - are a SUPER HERO! That worked. Simple as that. I am totally self taught on this stuff, so I have always been of the idea that it was better to reference more than less when there was multiple sub-forms. Clearly I am totally wrong there!!
I don't suppose you can explain that concept to me can you?