I have a user-defined type:
Public Type TaxRecord
Tax1 as Long
Tax2 as Long
Tax3 as Long
Tax4 as Long
Tax100 as Long
If I create a variable of type TaxRecord, such as:
Dim MyTax as TaxRecord
How can I refer to the ELEMENTS of the UDT via variables - or can I do that at all?
I would like to be able to do something like this:
For ctr = 1 to 100
varElement = "MyTax.Tax" & ctr
But that does not work for me - I get an error "Microsoft Access cannot find the name MyTax". In my experience with Access, Eval() rarely works at all for anything.
Is there any way I can refer to the elements of a UDT via variables?
Thanks in advance for your help.