I am trying to search for a particular order details in a subform (Recordsource-Orders) from the Customers main form (Recordsource- Customers).
Here I wanted to look for the customer details for a particular order from the subform. I need forum's help to search the entire orders table , find the value and show it in the subform so that I can find the customer details.
Thanks in Advance