T The Simonizer Guest Jun 27, 2001 #1 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?
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?
S snorf3 Registered User. Local time Today, 03:16 Joined May 25, 2001 Messages 45 Jun 27, 2001 #2 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.)
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.)
