Hi,
I have a Main form with a Subform1 which then has a Subform2.
On this Subform2, I have combo boxes that generate values based on values I chose in other combo boxes on the Subform2.
When I click away from the subform2 (that is, open up a different form while making subform2 no longer visible) and then come back to subform2, the values are still presented in those combo boxes.
How do I make it so that the combo boxes are blank upon return (re-visibility) of the subform2? Particularly, I know you have to use VBA and use the LostFocus event, but I have tried this and nothing seems to work. Perhaps someone can help me write the appropriate code for this.
Thanks,