Hold date in form.

[JudyT]

Entering multiple tickets with the same date. Would like to know if there is a way for Access to continue to display the last date entered until overwritten with new date?
Thanks.

 

[grnzbra]

Create a global variable to hold the value:

In Modules tab of Database window, create a new module called Globals and then, at top enter code:

Public DtHold as Date

Then, in the form's On Current event add code

Me!DateField = DtHold

and

in the form's On Change, add the code

DtHold = Me!Datefield.


You may also be able to do something like this with an unbound hidden field on the form instead of the global variable. You may also have to play with choices of events to get it to work just the way you want it to.

 

[2176]

Could you do that with something other than the date?? Say a control number. Instead of flipping back through to see the last control number entered.

 

[grnzbra]

I believe you could do it with anything. However, your statement about wanting to see the last control number sounds like you then want to add 1 to it to create a new control number. Having done this with member numbers, I would suggest some kind of code should be added to automatically generate the next control number.