L
LarryP
I have a form with a subform that is initially invisible. The user enters a
value on the main form, and the AfterUpdate event makes the subform visible
(the entered value is also used in a calculation within the query that feeds
the subform).
Problem is, the subform opens to a blank screen, nothing displayed. If I go
to design view, then back to form view, then change the entered value again,
the subform finally appears with data. The query itself is executing
correctly, I can run it and see the correct data, but for some reason the
subform won't display properly.
I've experimented around with {my subform}.Requery, no difference.
Any suggestions/explanations for this odd behavior?
value on the main form, and the AfterUpdate event makes the subform visible
(the entered value is also used in a calculation within the query that feeds
the subform).
Problem is, the subform opens to a blank screen, nothing displayed. If I go
to design view, then back to form view, then change the entered value again,
the subform finally appears with data. The query itself is executing
correctly, I can run it and see the correct data, but for some reason the
subform won't display properly.
I've experimented around with {my subform}.Requery, no difference.
Any suggestions/explanations for this odd behavior?