Hello All,

Basically I have a form with a 'Save Data' cmdButton, when the user clicks this they are prompted with a MsgBox (vbYesNo). If they say 'Yes' then I want to unload the form and then reload it again - assuming this clears all the data inc. arrays. Before the form is unloaded, I want to store some values on the form then put them BACK on the form once its been reloaded.

I tried a global varaible declaration, but it'll only last as long as the form - would the method be using the module to store/retrieve varables? If so how wouyld i go by doing this?

Hope this makes sense to someone out there. Thanks in adavance for any help!

Joe