Save number entered
Posted on 2014-03-27
I have an unbound field where I will be entering zip codes. The name is txtZipEntered.
Next to it is a button. When you hit the button it runs a report based on the zip code entered in txtZipEntered. I would like to enter code for the button that will save the zip code and a time stamp on a table. The table is called tblZipCodeHistory. This has two columns ZipEntered and TimeStamp.
Every time the button is hit, I want the table to be updated with a "ZipEntered" and a time stamp of when it happened.
Any idea the code of this?