>I have a class in which there is a grid that has 6 columns with info from a record. Below the grid are numerous textboxes reflecting info in other fields in the record. How do I get the 'other fields', who's controlsource is the record fields, to update as I go down the rows to reflect the info in the record now highlighted in the grid? I would have thought this would be automatic..
>
>Many thanks.
You need the AFTERROWCOLCHANGE event of the grid. Raise a method from there and refresh appropriate objects. I normaly have tgis stuf in an extra container, so I only need to refresh this container. Faster then the whole form.
It's also a good idea to not call the method directly, rather call a timer, so fast scrolling will not be slowed down by the refresh. There is a setting for the repetition of the keyboard, slightly longer will do.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]