Hi, I have a main form for creating/editing an order, a pop up subform for adding a product to the order and from there a pop up form to search part of the product name if they're not sure what Prod Type to use to filter to the appropriate product - the Search Part pop up is of necessity in datasheet view - the user would look at the available options and select best option - at the moment they then have the filter name to enter into the Add Product subform.
Any advice on how I would pass the selected record to the Add Product subform? More efficient than them having to enter it...
Any advice on how I would pass the selected record to the Add Product subform? More efficient than them having to enter it...