Copy data from one field to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JoeP - 19 Jul 2007 22:00 GMT

I have a form called participant. I data enter a date into a field called
StartDate. I would like to have that same date automatically be set as a
default in another field called InitialContactDate.

Can it be done and if so how?

Thanks.

JoeP

Reply to this Message

Douglas J. Steele - 19 Jul 2007 22:11 GMT

For the AfterUpdate event of the field, put code like:

Private Sub StartDate_AfterUpdate()

Me!InitialContactDate = Me!StartDate

End Sub

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I have a form called participant. I data enter a date into a field called
> StartDate. I would like to have that same date automatically be set as a
[quoted text clipped - 5 lines]
>
> JoeP

Reply to this Message