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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

user form, code placement 5
Access How Current page of a form Read Only 2
Form Updating 1
Access Sub form opens before the main form in MS Access 0
User Form issues 1
User form Text Box & Combo Box. 5
combo boxes 7
Close form when I press enter 1

Back
Top