Thanks to everyone for your ongoing feedback and support.
I have a Form frm_NewOrderEntry with 3 tabs each of which contains a subform. sfrm_NewOrderDetails, sfrm_Payments and sfrm_DeliveryDetails.
Each Subform has Required Fields in their properties.
I would like to do the following...
1 Ensure that at least 1 record has been created in each subform before the Main form closes.
2. Ideally. Force the user to navigate between the tabs in the OrderDetail, Payment then Delivery sequence.
3. In a Perfect World. Validate that the Sum of Payments in sfrm_Payments is >= Sum of Transactions in sfrm_OrderDetails.
Suggestions