Command button wizard will not populate correctly in Access 2007

Posted on 2009-04-27
Last Modified: 2013-11-24
I have always in other versions of Microsoft Access 2007 used the Command Buttons to open other forms from the "main form."  While my buttons that are already on the main form open the new forms fine, I am having problems while creating a NEW button.  
1) I click on the button tool
2) I select Form Operations for categories and Open Form for Actions
3)  "What form would you like the command button to open?"  I select the new form which is called "Next Contact Main" (which contains a Next Contact - sub as a subform as well)
4)" Do you want the button to find specific information..."  I select the first option to open the form and find specific data.
5) "Which fields contain matching data the button can use to look up information?"
The left column shows "Main Form" and the right column shows "Next Contact Main"
Normally, both columns would be populated with the fields on the respective forms, but in this case, the left column is empty so I can not select the common field which in this case would be the "Main ID" field.  The right column which is the "Next Contact Main" form is populated fine, but the left column is completely empty so it will not let me continue with the wizard.  (I've attached a snip of the issue as a png file)

Question by:sjmatlanta
    LVL 74

    Accepted Solution

    This will happen if your Main form is Unbound.

    This is because in an Unbound form, there are no real "Fields" only textboxes.
    Hence there are no fields to display in the dialog box.

    If there is a value you wish to join the two form on than you will have to do it through code.

    The Button wizard was not meant to handle situations like this.

    The code might look something like this:

    Private Sub cmdOpenFormForSpecificMovie_Click()
        DoCmd.OpenForm "frmDetailVideos", , , "MovieID=" & Me.cboMovie
    End Sub

    Here is a sample




    Expert Comment

    I am having this exact problem.  The wizard worked in Access 2003,  even if the form was unbound.

    Expert Comment

    I just stumbled over this as well and the main form is bound.  It was working but now its not.  

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    758 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

    10 Experts available now in Live!

    Get 1:1 Help Now