OK, I have formA with a field called txtMPMS which is a 13 digit number. After user have added information on this form they need to open FormB. Form A stays open in the background. When Form B is open in Edit mode.

When user click add new record in FormB, I want the value entered in txtMPMS to be displayed in FormB. I have too many user who get typing in the incorrect number. I want the value to appear in FormB only when the user is adding a new record in formB.

I tried referrencing the control in FormA but using Forms![FormA]![txtMPMS] but i didnt have much luck.

Would I better of coding something similar to this

So what Im after to have value from txtMPMS copied in txtMPMS in FormB only when its a new record.