Auto-Populate unbound form field upon load

Last week i got assistance to link two fields(Bound & Unbound) together so when i selected the unbound field, it auto populated the data listed in the table.  Now i can make changes to that data and keep it linked to the regional field on that table.  The problem i am encountering now involves the unbound field not autopopulating when the form is opened.  Although it is linked to the first record which is region 1 and the data is populating for that region, the unbound field remains blank.  I believe this can be fixed by using an event procedure for on load, but i could not understand the examples i found on the Internet.   I do have the bound region field present in the form, but hidden so it doesn't confuse the users.    Attached is a copy of the database.  

Who is Participating?
Eric ShermanAccountant/DeveloperCommented:
This should work ...

Private Sub Form_Current()
     Me.cboregion = Me.Region
End Sub

Eric ShermanAccountant/DeveloperCommented:
Try using the Forms OnCurrent Event.

jsawickiAuthor Commented:
Worked perfectly, thanks a bunch.....
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.