I have a main form named "fromRovingPatrol_01" and a subform on that form named "fsubArrests". There is a textbox on the subform named "Text27" which contains a dlookup function to get a code number. I need to assign the value of "Text27" to the "Code" textbox on the same subform.
I need this code to run during an AfterUpdate event on the subform. I have tried this piece of code to no avail;
Forms![frmRovingPatrol_01]![fsubArrests].Form!
I need this code to run during an AfterUpdate event on the subform. I have tried this piece of code to no avail;
Forms![frmRovingPatrol_01]![fsubArrests].Form!
Code:
= Forms![frmRovingPatrol_01]![fsubArrests].Form![Text27]
I have also tried several variations that do not work. What am I doing wrong? Thank you in advance. Troy