I have a form bound to a table that displays a subform whose contents come from a different table. The 2 tables are related one-to-many. The subform displays a list of items in a shipment and allows the user to enter a tariff code, weight, and country of origin. The user can also add items to the shipment (add records to the table). The main form collects information about the shipment, such as ship date and FedEx number.
When the user is finished editing the shipment details in the subform and entering the shipment information on the main form, he clicks on a Done button which prints shipping documents and exports a text file.
Here's what I need:
When the user clicks on the Done button, search through the data in the subform and make sure that all fields are filled out (not blank) and all fields have valid data ( e.g. weights and unit prices are not zero). If any field fails this check, display a message and place the cursor in the field that has the problem.