find on subform and display mainform

[paulhenley]

I have a sales database and one of the forms has the sales order header table as the main form with the sales item details table as the subform. I need to be able to allow users to search for records in the details form (subform) and when found, display the relevant information in the main form (sales header).
I have tried many ways to do this without success. The main problem that I have is that When I open my form I am only displayed the sales items(subform) for the current Header. What I need to do is search on all items for all orders.

Please can anyone help?