Hi,
Just wondering if I am going the right way about this and if someone could point me in the right direction? I have a main form and subform. The main form shows the master quantity e.g. 80 and then the subform shows the individual boxes of 8.
Can I get the subform to filter to show only 10 records (totaled to 80) with the oldest create date? Not sure how to handle the onload event of the subform to get the oldest and to just total 80. The total is throwing me.
If this is achievable and lists my 10 oldest records totaling 80. Can I then put an event on the "Scan BoxID" field, where the user scans the BoxID, and if in the subform, the row will highlight and the user will have the option to scan the masterASN and BoxSerial before moving onto a new box. The user may no be scanning the boxes in order.
I have been looking at this for a bit too long and want to make sure I am going in the correct route.
Thanks in advance.
Just wondering if I am going the right way about this and if someone could point me in the right direction? I have a main form and subform. The main form shows the master quantity e.g. 80 and then the subform shows the individual boxes of 8.
Can I get the subform to filter to show only 10 records (totaled to 80) with the oldest create date? Not sure how to handle the onload event of the subform to get the oldest and to just total 80. The total is throwing me.
If this is achievable and lists my 10 oldest records totaling 80. Can I then put an event on the "Scan BoxID" field, where the user scans the BoxID, and if in the subform, the row will highlight and the user will have the option to scan the masterASN and BoxSerial before moving onto a new box. The user may no be scanning the boxes in order.
I have been looking at this for a bit too long and want to make sure I am going in the correct route.
Thanks in advance.