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:
Ah yes, the old 'can't access individual repeater fields' issue. I have
addressed this in a separate answer, under the title Set focus in
this repeater grouping.
You can use a similar method to get the handles of each of the objects in a
repeater, probably by using a global array. [This would be ideal for a
recordset, but I don't believe you can store object handles in a
recordset.] You would then have to keep track of when the rows in a
repeater scrolled. You can do this by turning off the scroll bar for the
repeater and adding a scroll bar as a separate object next to the repeater
that would control the movement through the repeater. Or, you could use up
and down push buttons, as described under the title Pushbuttons for
repeater movement in this grouping of questions.
Once you can track changes in the repeater, you can design a function to
walk through the individual objects in the repeater and enable or disable
them, depending on the values in the underlying row of the recordset.
I haven't actually tried to code this all myself, but it makes sense
that it would work.