Access 2007 Form & Query Parameters

[PeterS]

In Access 365 the parameter used in a query that is opened by a form with a combo box looks like this;

[Forms]![frmNAME]![cboNAME]



When completing the criteria in the query, you are prompted on what to populate......all in all very easy

If I use the same approach in Access 2007 there is no prompting and the parameter looks like it does nothing except prevent the form form working at all.

ie: if the combo box offers a selection criteria such as Customer_Name and the Command Button has a Run Report event on click then the report opens unpopulated. If I remove the combo box and the paramater criteria in the query then the report opens perfectly, only not filtered by Cusomer_Name.

[ranman256]

It works if the combo has a value.
it will not if the combo is empty.

[PeterS]

If I select the Customer_Name from the combo Box then click on the command button the report opens blank. What do you mean the combo box needs a value?

[orange]

Can you post a copy of the database in zip format with only enough data to highlight the issue?

[Gicu]

You shouldn't be prompted again for the criteria if the query takes the value from the form. Are you placing the form reference in the right field of the query? Most combo boxes have two columns, one holding the unique id (CustomerID) and being hidden, and the other holding the descriptor (CustomerName). Even if the combo shows you the name you have to place [Forms]![frmNAME]![cboNAME] in the CustomerID field if that is the bound column.

Cheers,
Vlad