Hello
I have a subform which is displayed in continuous format. For this problem though, I think it would be the same if it was a form, not a subform.
Depending on the value of each record, I want to display different controls. For example, a combo box to set the value of a given field, which is only relevant for some records.
I have tried using VBA code to show or hide (or enable, un-enable) the appropriate controls depending on the value of a given record.
The problem is that it shows or hides them for all the records at once, rather than just the current record.
Does anyone know if/how you can set the control properties for individual records in a continuous form?
thanks
Dan
I have a subform which is displayed in continuous format. For this problem though, I think it would be the same if it was a form, not a subform.
Depending on the value of each record, I want to display different controls. For example, a combo box to set the value of a given field, which is only relevant for some records.
I have tried using VBA code to show or hide (or enable, un-enable) the appropriate controls depending on the value of a given record.
The problem is that it shows or hides them for all the records at once, rather than just the current record.
Does anyone know if/how you can set the control properties for individual records in a continuous form?
thanks
Dan
