I have an unbound Text Control on a main form. My user may either type in a value, or invoke a subscreen to perform a lookup operation for the relevant value to be placed into the main form text field. I have supplied a button on the subform which may be depressed with the subsequent action of placing the "found" code value back into the main form's Text Control. When I test this feature, any prior visible value in the Text Control remains visible as the prior value. However, if I then reposition the record of the main form, and then reposition back to the main form record in which I had attempted to insert this new found value, I find that it has changed to the new value.
My question is how can I get the visible value to change to the newly inserted value by use of VBA code associated with the subscreen button, without doing the record juggling act in the main screen?