Help with passing from combo box to query

[wgma]

I have a form with a combo box. I need to pass the value of the combo box to a query that will in turn populate a report. Everything that I have tried so far does not work.

Can someone please help me?

Here is what I have so far:

QUERY -- qryManifestHeaderShip
SELECT tlbShip.ShipName, tlbShip.ShipNationality, tlbShip.NameOfMaster
FROM tlbShip
Where (tblShip.ID=forms!frmBillOfLading!cboExportCarrier);

CALL FROM FORM --
DoCmd.OpenReport "rptManifestHeader", acViewPreview

The recordsource for the report is the query

Each time that I try to run the report I am prompted for the parameter.

Thanks.

 

[Remou]

Is the form frmBillOfLading open? Have you double-checked the spelling or tried the expression builder?