PC Review


Reply
Thread Tools Rate Thread

Copy data from one field to another

 
 
=?Utf-8?B?Sm9lUA==?=
Guest
Posts: n/a
 
      19th Jul 2007
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 With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      19th Jul 2007
For the AfterUpdate event of the field, put code like:

Private Sub StartDate_AfterUpdate()

Me!InitialContactDate = Me!StartDate

End Sub

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


"JoeP" <(E-Mail Removed)> wrote in message
news:4648CCF0-1D8B-41B6-8978-(E-Mail Removed)...
>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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to sort (by one field), copy (based on one field) to another tab,then clear data on original sheet. Mel Microsoft Excel Programming 3 17th Apr 2009 09:18 PM
Copy Data from SubForm Field to Main Form Field ridgerunner Microsoft Access Forms 6 21st Mar 2008 02:17 PM
automatically copy data from one field to field in same table =?Utf-8?B?dGFuaWE=?= Microsoft Access Database Table Design 0 20th Sep 2004 04:31 PM
changed value on form to copy data from field into another field Derek Davlut Microsoft Outlook Form Programming 1 15th Apr 2004 09:21 PM
Copy A Tables Field Data To Another Field In Same Table Chris Moore Microsoft Access Getting Started 5 28th Jul 2003 09:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:06 AM.