I have a form of club members with a continuous subform on it showing boat
details.
I hold the boat length and beam (in meters) in a table. On the subform I
also calculate and show the imperial equivalent length and beam. You can
enter lengths in either the metric box when an AfterUpdate event shows the
imperial eqivalent, or converseley you can enter the lenght in feet and
inches in the imperial box and on AfterUpdate the metric equivalent is
displayed and stored in the corresponding metric box.
The appropriate imperial measurements are calculated OnCurrent of the
Subform
The problem is that the the same calculated fields are displayed on every
record on the subform + the blank new record corresponding to the current
record. Is there any way of hiding and locking the Imperial calculated
fields on all but the current record. Its a sort of conditional formating on
the current record.
TIA
Phil