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?
|
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!!! |