I've also found a better way to deal with the problem I had trying to automate the process of copying data from one field to another on data entry.
Perhaps you would like to share your "better way" with the rest of us. That's sort of what the forum is about/encourages. We can all learn.
You probably know it already https://accessworld-accessworld.netdna-ssl.com/forums/images/smilies/smile.gif but what I was trying to do was display 2 of more fields (using a 'lookup box' from a relational table on the same form as all the data from the main table. It would only pick one field. I though I would have to have 2 or more fields in the main table but didn't work & I couldn't combine them . Found that I could add the same field 2 or more times on the form & bind each to a different field in the relational table. Works fine (probably a better way still lol).