Using one field's value as the default for another in a form

[pelcovits]

I am trying to set the default value for one field (call it Field2)in a
form to equal the value of another field (call it Field1). I have read
enough on the web to realize that I should be writing VBA code in the
AfterUpdate event for Field1. I have tried many different ways (too
many to enumerate here) with no luck. Both fields are currency.
Any help would be very much appreciated.

thanks

[Mark]

I'm no programmer so don't take this as gospel but you could give this a
try.

Both fields are in the same form:
In the AfterUpdate event of field1 try: Me.Field2.Value = Me.Field1.Value

Fields are from different forms (and they are both open):
In the AfterUpdate event of field1 try: Forms!FormName!Field2 =
Forms!FormName!Field1

Regards,

Mark
<pe*******@physics.brown.edu> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

I am trying to set the default value for one field (call it Field2)in a
form to equal the value of another field (call it Field1). I have read
enough on the web to realize that I should be writing VBA code in the
AfterUpdate event for Field1. I have tried many different ways (too
many to enumerate here) with no luck. Both fields are currency.
Any help would be very much appreciated.

thanks