Hello guys!

I have 3 forms: Manufacturers, Products and Production Requests.

The form Production Request has 2 search fields: manufacturer and products. Selecting the Manufacturer it will load the products list from that manufacturer into the search field "Product".

I'm look for a way to have a button on my report Products to open a new form "Production Requests" with the values of Manufacturer and Product loaded and selected into the search box fields on that form. Any idea about how to do that?