Default Values

  • Thread starter Thread starter A. Hatheway
  • Start date Start date
A

A. Hatheway

I have a very simple form. It has a member ID, a date, an amount
contributed, etc in that order.

How can I get the default value for the date to be the date last entered (on
the record before)? In other words, as I go from record to record, I want
the date to stay the same unless I change it.

Can anyone help?
 
A. Hatheway said:
I have a very simple form. It has a member ID, a date, an amount
contributed, etc in that order.

How can I get the default value for the date to be the date last
entered (on the record before)? In other words, as I go from record
to record, I want the date to stay the same unless I change it.

Can anyone help?
Click to expand...

In the AfterUpdate event of DateLastEntered:

Private Sub DateLastEntered_AfterUpdate()

With Me!DateLastEntered
.DefaultValue = Format(.Value, "\#mm/dd/yyyy\#")
End With

End Sub
 
Thank you very, very, much. It works great!


Dirk Goldgar said:
In the AfterUpdate event of DateLastEntered:

Private Sub DateLastEntered_AfterUpdate()

With Me!DateLastEntered
.DefaultValue = Format(.Value, "\#mm/dd/yyyy\#")
End With

End Sub

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top