Update Access field from a button on a second form
I have two forms. In one form, I am pulling Full names and users names. The other form is used for data entry. I want to see if I can (after data is retrieved on form 1) add a button on form one that will take the username and populate it in one of the text fields on form 2.
Trying to make this easy for my end users.
As a note, both of my tables are ODBC SQL tables. This should not matter but wanted to be sure it was stated.