Once a form is initialized is it initialized until the application ends? When you hide a form it doesn't clear so I assume it stays alive and is just hidden. I want to collect data from a worksheet and display it in the form that was used to originally gather the info. So working with the select row I just gather the info and assign it to the fields in the form. What kind of traps can I avoid?
Edit: I found one problem I need help with. When I run the form originally the OK runs a routine that places all the data on the worksheet. This, of course fires the selectionchange of the worksheet which is the routine that I am using to read the data into the form. How do I tell the worksheet to ignore the selection change when it is info being added?
Bookmarks