Hi All,
I have a form with 2 sub forms
When i select a record in the first sub form by clicking on it / in focus, i want the order number to be highlighted.
then in the second sub form, all the orders with the same order number I want to be highlighted
what i did was is use conditional formatting in the second sub form when the order number is the same as the in focus on the first sub form but it is not working as hoped for
I have a form with 2 sub forms
When i select a record in the first sub form by clicking on it / in focus, i want the order number to be highlighted.
then in the second sub form, all the orders with the same order number I want to be highlighted
what i did was is use conditional formatting in the second sub form when the order number is the same as the in focus on the first sub form but it is not working as hoped for