• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 687
  • Last Modified:

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.  

Thanks.....
Sparing-pool.accdb
0
jsawicki
Asked:
jsawicki
  • 2
1 Solution
 
Eric ShermanAccountant/DeveloperCommented:
Try using the Forms OnCurrent Event.


ET
0
 
Eric ShermanAccountant/DeveloperCommented:
This should work ...

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

ET
0
 
jsawickiAuthor Commented:
Worked perfectly, thanks a bunch.....
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now