How can I set focus to each detail row of a subform in a way that will cause a data-refresh?
Posted on 2013-01-21
I have a MS-Access 2007 form with a subform within it. This subform has header, detail, and footer sections. Within the detail section I've placed a couple of data-bound controls (ListBoxes). These work great, but only when a detail row gets focus. There are usually about 3 details showing at one time and only the first one shows the correct data when the form opens. The user currently has to click into each detail row to get the current data to show for those rows. In the code if I just programmatically set the focus to one of the problem rows it doesn't help. So far only the mouse clicking by the user causes the data to refresh. Anybody dealt with this?