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.

unload me

regards
r

Il mio ultimo lavoro ...
http://excelvba.altervista.org/blog/...ternative.html


"Steve" wrote:

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
---------------
Jacob Skaria


"Steve" wrote:

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.

Unload me it is then....
That appears to have worked-- thank you both R, and Jacob.