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

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

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


<pelcovits@physics.brown.edu> wrote in message
news:1105235636.791089.308860@c13g2000cwb.googlegr oups.com...[color=blue]
>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
>[/color]