Question:
Is there a way to enable and disable fields inside a repeater display depending on the values of fields on the master form?I have tried it various ways (on the master form, on the repeater) but I have got the always present “Repeater controls can oly be used with agregation functions.”
Answer: You can use a similar method to get the handles of each of the objects in arepeater, probably by using a global array. [This would be ideal for arecordset, but I don’t believe you can store object handles in arecordset.] You would then have to keep track of when the rows in arepeater scrolled. You can do this by turning off the scroll bar for therepeater and adding a scroll bar as a separate object next to the repeaterthat would control the movement through the repeater. Or, you could use upand down push buttons, as described under the title Pushbuttons forrepeater movement in this grouping of questions. Once you can track changes in the repeater, you can design a function towalk through the individual objects in the repeater and enable or disablethem, depending on the values in the underlying row of the recordset. I haven’t actually tried to code this all myself, but it makes sensethat it would work.
Ah yes, the old ‘can’t access individual repeater fields’ issue. I haveaddressed this in a separate answer, under the title Set focus inthis repeater grouping.
