Which is better, to call a module from a form or to call a form from your module? I have always had to create a sub that did nothinng more than call a form, gather my data, and then send it to another module to process. Yesterday I got to thinking, (scary huh) why did I need 2 subs, why not have 1 that calls the form, and then processes the data on it.
Long story short, how do I capture the cancel button on the form to quit out of the calling sub? The button has Unload Me, but that just dumps the form contents, but doesn't quit out of the calling sub. I thought about checking the values of the data boxes on the form, but what if the user fills out all the boxes, and then hits cancel. The boxes would have data, so it would try and continue. I guess I could use the cancel button to clear a data box, then check it for nil and dump that way. Any suggestions?