View Full Version : Holding Data in a Form


The Simonizer
06-27-2001, 09:43 AM
I have a form that is used for donation entry. We enter all donations for a specific date at one time. How would I get a form to hold that date in a list box until I close the form?

snorf3
06-27-2001, 01:28 PM
In the After Update event of your date field text box put this code:

Me![Date].Tag = Me![Date].Value

Then, in the On Enter event of the the date field text box put htis code:

If Not (IsNull(Me![Date].Tag) Or Me![Date].Tag = "") Then Me![Date].Value = me![Department].Tag
End If

Make sure you change [Date] to whatever your date field name is. This should cause the date to carry over to the next form until you close the form.

(Thanks to Jack Cowley for the code.)

The Simonizer
06-27-2001, 01:49 PM
Thanks so much!!! It worked just great! Love this site!!!