Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL
Expertise: Beginner
Apr 1, 1997



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Enabling and disabling fields in a repeater

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."

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.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date