Holding Data in a Form

[The Simonizer]

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]

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]

Thanks so much!!! It worked just great! Love this site!!!