Auto-Populate unbound form field upon load

Posted on 2012-09-17
Last Modified: 2012-09-17
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.  

Question by:jsawicki
    LVL 19

    Expert Comment

    by:Eric Sherman
    Try using the Forms OnCurrent Event.

    LVL 19

    Accepted Solution

    This should work ...

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


    Author Closing Comment

    Worked perfectly, thanks a bunch.....

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now