i know there has been a lot of posts on refreshing/requerying comboboxes. But I cant seem to get it to do what i want.
i've got a bound subform set to continuous forms on a bound form that has a combobox that looks up values in another bound form, and in the AfterUpdate Event the following code.
Expand|Select|Wrap|Line Numbers
- [AreaAllowed] = [WorkstyleDefID].[Column](2
- OccupantWorkstyle] = [WorkstyleDefID].[Column](1)
This is working but not how I want it to. What i'm finding is it's only updating the record that has focus. I'd like all instances of records visible on the continuous form to requery.
Is this possible? Thanks