M
mitchbvi
Guest
I have been trying to write code that will open a past sales record form filtered by the client reference (in the parent form (a new order)) and the product reference (in the subform). The action occurs after the product reference in the subform loses focus. The intention being that the last quantitied ordered will be entered into the qty field in the new order (as a suggestion to the operator who normally takes orders by phone. I can open the form using DoCmd.Openform and setting open args to the client field but cannot work out how to combine the two fileds. Any suggestions please
