upon returning to a form

prmitchell

Registered User.
Local time
Tomorrow, 00:39
Joined
Jan 2, 2013
Messages
58
Hi
I have a form with a combo box that opens another form to the user's selected value and then when the user has finished with the second form and closes the user is then back at the first form - but the value in the combo box is still shown. I know how to program to clear that - as I can add a button for the user to click on - but I would like the combo box to be cleared when the user is returned to the first form.

I thought this would be the On Activate event - as I thought I had achieved this successfully in the past.

Might someone suggest where I place the code to clear the value in the combo list.

Thanks.
 
one way is to wait for the first form to close, and then carry on

eg

Code:
buttonclick event
 
DoCmd.OpenForm "myform"
While IsLoaded("myform") 'wait for form to close
     DoEvents
Wend
 
now reset combo box
 
etc
 

Users who are viewing this thread

Back
Top Bottom