Report Controlled by a drop box

[mslenker]

Now I know this is a stupid question, because I've done it before but I am drawing a blank on how to do it. I want to use a drop box to select a particular machine and the subreport to show all the open orders for that particular machine.

[rpeare]

if you're talking about using a currently selected item on a form to be the criteria for a query or report the syntax in the query line is:

[forms]![formname]![fieldname]

So if your form is named Main_Form and the field you want to use as a criteria is called [Search_Item] your syntax would be:

[forms]![Main_Form]![Search_Item]