I have got a main form with a subform that is set to Continuous.
What I want to do is hide certain fields depeneding upon values within the current record.
Therefore if viewing the Subform and there are 4 reocrds the individual rows should display different fields.
I have tried several ways but if I try to hide a field on one row because it meets that criteria the the field gets hidden for every row. I am obviouslky missing something simple here.
Any help would be appreciated.
What I want to do is hide certain fields depeneding upon values within the current record.
Therefore if viewing the Subform and there are 4 reocrds the individual rows should display different fields.
I have tried several ways but if I try to hide a field on one row because it meets that criteria the the field gets hidden for every row. I am obviouslky missing something simple here.
Any help would be appreciated.