Auto populate a field from another source

[NoellaG]

Hi,



you can try to put the expression

me.MRR_NO = me.text145

in the Form_AfterInsert event

gr
NG

[gbullo]

Vitols,

I'm not sure you understood what my confusion was about and this didn't really help.

My form name is "FrmAssignMRR1"
Record source (table) = MRR Table
Field name = "text145" (this is the autonumber field which is assigned when adding a new record)
Field name I want the value from text145 to be populated with = "MRR_NO"

What I need is the value from "text145" to automatically populate into field "MRR_NO" rather than type it in manually.

So based on the form name, my two field names I am working with, would the code look like this?

Forms("frmassignmrr1").Controls("MRR_NO") = lngNumber

And would this code be placed in the after update properties of the form "frmassignmrr1" or the text field where the autonumber is populated when a new record is created "text145"

George