-
1
- #1
I have a form that has several different address type fields. I want to put an event in the after update property of each of the fields that will capture the data from that field into a variable. Then when the form is closed, or is moved to a new record, I want to dump all the variables into a table. If I move to a new record, I may want to re-assign the variables again and dump them and so on. (I'm trying to capture address changes to print them on a report.)<br>
<br>
I'm having problems with the variables not being stored, and I'm pretty sure it has to do with how I have declared them--I tried using the public statement at the module-level but for some reason it interfered with a combo box that I have on the form. I also tried using the static keyword, but couldn't get it to work. It's seems like a pretty simple thing I need to do, but I'm doing something wrong!<br>
<br>
Thanks for any help! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>
<br>
I'm having problems with the variables not being stored, and I'm pretty sure it has to do with how I have declared them--I tried using the public statement at the module-level but for some reason it interfered with a combo box that I have on the form. I also tried using the static keyword, but couldn't get it to work. It's seems like a pretty simple thing I need to do, but I'm doing something wrong!<br>
<br>
Thanks for any help! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>