I'd like to concatenate 2 fields on a form into a field in a table -

Thanks

You did not say if and how your form is bound and to which table, or if the
result field is in the same table.
Basically, you can create a hidden text box txtResult bound to the field you
wish to update. For the other 2 fields on the form, in the AfterUpdate for
both set: me.txtResult = me.txtF1 & me.txtF2

--
Mike S.
Optimal Systems www.oscorp.com
--
"Chris Carswell" <ccarswell (AT) NOSPAMeclipse (DOT) co.uk> wrote