Pass Parameter from Form Combo to Report

[Jackson1942]

Working with Access 2010 and need some help. I have defined and populated my tables; Team table contains an entry for every employee that works on that team and a Employee table that contains basic contact information; phone numbers and email addresses.

For example: Team 1 contains 3 employee entries, one for the manager and 2 for staff members. Employees and managers are on multiple teams.

I have Query1 that pulls the information from the tables.
I have a report (ServiceCallList) that displays the information from Query1.

Query1 has [Teams] in the Criteria area for the Teams entry.

I run the report and the “Enter Parameter Value” display opens up; I enter the team and it displays properly.

I have created a Form (Form1), defined a Combo Box (Name is Combo8) from the Teams table, hoping to be able to select a Team from the combo box that will automatically pass to the Report (ServiceCallList) and display the results for that Team only.

I have changed the [Teams] criteria to [Teams]!ServiceCallList.Combo8 in Query1.
I added an “Open Report” macro to Combo8 for the ServiceCallList report.

When I select an entry from the Combo Box in Form1, the “Enter Parameter Value” displays?

While searching this web site I see a lot of information for Me. and DoCmd. statements not knowing what they are for; not knowing SQL or VB could someone help me out?

 

[pbaldy]

Your reference to the combo is incorrect. This should help with syntax:

http://www.mvps.org/access/forms/frm0031.htm

You want the full reference, starting with "Forms!"

 

[Jackson1942]

Thank you Paul for the quick reply. Took a look at the link that you provided and tried different methods with no luck. I have built a test database using data from the original and; created the tables with relationships; created Query1, created Report1 using Query1. Created a Form1 with a List Box and a Combo Box. I built an Event for each that Opened Report1. I added

[Forms]![Form1]![Combo2] to the Team-ID Crietera. (Combo2 is the Name not the lbel)

I selected a item from the Combo Box and the report header came up with no data.

I am attaching the test database so that you can see what I have built.

Changed [Forms]![Form1]![List0] to the Team-ID Crietera. (List0 is the Name not the label)

I selected a item from the ListBox and the report header came up with no data.

All help and assistance is appreciated.

The University is closed starting today through January 3, 2012, but I will be checking from home.

 

[pbaldy]

You're comparing apples and oranges. Your query is looking for the Team-ID field (403b) but the bound column of the listbox is the ID field (3).

 

[Jackson1942]

Thank you, it works, and I really appreciate the help.

 

[pbaldy]

No problemo!