I was wondering if there is anyway to make a group of controls on a report into an array.
Why you ask?
Well, I have a query that contains a main record, and two other related records, that could be the same. To clarify, I have a main table and a secondary table. The main table was within it two feilds that are keys to the secondary tables. It is possible for these to be the same, so if they are, in my report I want to make the controls holding the second secondary tables info invisible.
I have tried making the names the same, but it won't let me do that.
If anyone has any ideas, I would love to hear them.
Thank you
Why you ask?
Well, I have a query that contains a main record, and two other related records, that could be the same. To clarify, I have a main table and a secondary table. The main table was within it two feilds that are keys to the secondary tables. It is possible for these to be the same, so if they are, in my report I want to make the controls holding the second secondary tables info invisible.
I have tried making the names the same, but it won't let me do that.
If anyone has any ideas, I would love to hear them.
Thank you
