user form issues

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

morning all.
I've created a user form and while it's getting close to what I want, I'm
noticing that when I go to access it a subsequent time after, the combo box
fields are still populated from my previous use.

How do I prevent this from occurring?
In my code I have Me.Hide, which acts to close the form.
I don't however see anything close to the idea of
me.depopulateformfieldsonclose, or me.emptyformfieldsonclose.

Thank you.
Oh-- this is the first form that this has happened to, and I've made 7 other
forms-- albeit this is my first with combo boxes.
Best.
 
Instead of Me.Hide unload the form and load as and when required

'To unload
Unload UserForm1

' To load
Load UserForm1
UserForm1.Show

If this post helps click Yes
 
Back
Top