Constant( changeable) date in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've tried this a dozen ways and still can't get what I'm after

I have a form for data entry. I would like the date to stay the same as the prior entry in the form until changed eg..

first form slipdate 12/05/04 go to next form shows the date as 12/05/04, got to third form and change the date to 15/05/04 go to fourth form it shows date as 15/05/04.
Someone kindly gave me the code Me!slipdate.defaultvalue=Me!slipdate for afterupdate. All this does is give me the value #name? so I know the code is wrong. Can anyone tell me how to do this, I have seen it done so know its possible, it save a lot of time in data entry. Thanks
 
Someone kindly gave me the code Me!slipdate.defaultvalue=Me!slipdate for afterupdate. All this does is give me the value #name? so I know the code is wrong.
Click to expand...

Use quotes:

Me!slipdate.defaultvalue = Chr(34) & Me!slipdate & Chr(34)

Even though the field may be date/time, its Default property needs to
be a text string.
 
Back
Top