Filter Issue?

[dragongunner0351]

Hello all I have a Customer Order form that has a control (button) that when clicked will open all repair work orders for that customer. Here is the code behind the button:

DoCmd.OpenForm "Repair Work", , , "[Repair Work]![CustomerID] = " & Me![CustomerID]

Works great when the button is pressed however, it prompts the user to enter the company name of the customer who's repair work you want to view.

Perhaps I need to explain that 1st the user clicks on the menu option view customer orders. Then select the company that want to see the orders for. Next they click a button to view previous orders. Here they can drill further into the order to see the details like....Repair Work.

I was hoping that I could code the button to automatically filter based off of the customer that is currently being viewed. Any help is greatly appreciated

 

[Remou]

Does the report contain a field 'company name', did it previously contain such a field or was a field formerly called 'company name' renamed? If so, check the report for any where this name could occur, sorting and filters for example. Check the query, too, if the report is based on a query.

 

[dragongunner0351]

I will try your suggestions, the report does have a field called companyName

Thank you