I have a complex database with heaps of forms and extensive use of subforms.
I sometimes have to use continuousforms in a subform and generally this is fine for simple lists of records.
However, I need to format each record for the following:
1. if record is archived, title is formatted with rd text. if not archived (ie current) then title should be green text.
2. a similar type date condition sets the background form colour to a different colour.
3. the value of a field determines if another field is displayed or enabled.
The problem comes when running the form - when scrolling through the continuous forms, the formatting is applied to all the forms. So, all the records will have the formatting of the last record in the cnt. form.
I think this is a problem which cant be "fixed".
I have tried using conditional formatting but this is linked to one field and only allows text colour or font changes. It doesnt allow visiblility properties to be set or enabled/locked settings. So this is not the answer.
I hope there is a solution as I cnt see another way around progamming this normally.