Command button wizard will not populate correctly in Access 2007

Posted on 2009-04-27
Medium Priority
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

Jeffrey Coachman earned 1000 total points
ID: 24246681
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

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

Expert Comment

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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

831 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