View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default user form issues

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.