Default Values

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

 

[Dirk Goldgar]

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?

In the AfterUpdate event of DateLastEntered:

Private Sub DateLastEntered_AfterUpdate()

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

End Sub

 

[A. Hatheway]

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

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)