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

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

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]