I've got a Form with 2 fields that are usually going to be the same, but
not always (hence, the need for a separate field).

When a user entering a new record types in the first field's value, I
want the 2nd field to be automatically populated with the 1st field's
value.

Alternatively, could I set up an "insert trigger" (that's what I'd call
it in the RDBMS I'm used to using) to automatically set the 2nd field
the tha value of the first IF (and ONLY if) the 2nd field is blank.

I'd prefer to do it the first way, but since I'm just learning Access,
I'd also be interested in how the 2nd would be accomplished, if it's
possible.

Thanks in advance