Main form has a text box with datepicker.
TextBox AfterUpdate event uses textbox value to change recordsource in subform then refreshes the subform which contains conditional formatting.
If I type-in a date and press TAB to leave the textbox, everything works as expected.
If I use the datepicker to choose the date then press TAB, the conditional formatting in the subform does not refresh until I click the mouse in the subform.
I have tried every form of requery, refresh and recalc in many events in main form and subform (load, open, activate) But since it works fine when the date is typed in, none of the obvious solutions like this work.
I have seen a few posts describing this scenario but no good solutions. The only one I have seen that might work is to momentarily open a small dummy popup window. Is there are a better solution or this this a confirmed bug?
TextBox AfterUpdate event uses textbox value to change recordsource in subform then refreshes the subform which contains conditional formatting.
If I type-in a date and press TAB to leave the textbox, everything works as expected.
If I use the datepicker to choose the date then press TAB, the conditional formatting in the subform does not refresh until I click the mouse in the subform.
I have tried every form of requery, refresh and recalc in many events in main form and subform (load, open, activate) But since it works fine when the date is typed in, none of the obvious solutions like this work.
I have seen a few posts describing this scenario but no good solutions. The only one I have seen that might work is to momentarily open a small dummy popup window. Is there are a better solution or this this a confirmed bug?