Query paramater for report

[Hayton]

Hi All,

I have an application with three forms a Main form and two subforms. frmCustomer is the main form sfrmFlt the first subform and sfrmData the second subform. On dfrmData I have a button to run a report from a query called qryRepData.

One of the parameters is a comboBox (cboFlt) which resides on the first subform (sfrmFlt). When i run the report the query does not pickup the values from cboFlt. I have tried using this "[Forms]![sfrmFlt]![cboFlt]" parameter and variations there of but to no avail.

Any suggestions will be greatly appreciated.

Hayton McGregor

 

[dhookom]

You have to use syntax like
Forms!frmMainFormName!sfrmControlName!Form!txtOnSubform

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]