Two Results

D

Daniel

Hi Guys!!!

Basically when my data entry people enter a result I need the one single
result to go into two different fileds

For example having the date "29/01/08" go into the field Todays Date and the
field Current Date
 
A

Allen Browne

In your form, use the AfterUpdate event procedure of the first text box to
assign the value to the other one as well.

Say you have text boxes named Date1 and Date2.
In form design view, set the After Update property of Date1 to:
[Event Procedure]

Then click the Build button (...) beside this.
Access opens the code window.

Add this line between the Private Sub... and End Sub lines:
Me.[Date2] = Me.[Date1]

In general, you only want to do this kind of assignment if the user may need
to be able to change Date2 to something else. More info:
Calculated fields
at:
http://allenbrowne.com/casu-14.html
 
A

akphidelt

Try doing an afterupdate event

It would be something like

Me.txtCurrentDate = Me.txtTodaysDate
 
Top