Hello I have a table containing 5 key fields. An entry into Field 1 (Weight Collected) displays Fields 2,3 and 4 (ShowIF Weight Collected >0). When the new fields (2,3,4) are displayed, the thought is the user will be directed to the next visible field for entry, Field 2 (Weight Shoes). The system directs the user to Field 5 (Trash) instead and bypasses 2, 3 & 4 completely.
The form is based directly on the table due to other requirements.
Is there something I should be adjusting for form to follow the fields on screen? Any help would be greatly appreciated.