OK I am not even close to a novice on this but I am stumped so the easier the explaination the better.
I am creating a scan/verification app for pre-printed barcode tickets. The form called frmscan is based on a table called tblscan which contains 10 fields. Spart1, Spart2, 3, 4, 5 and VPart1, 2, 3, 4, 5. What will happen is the user will scan in barcode labels (Spart1, 2, 3, 4, 5) and verify them against VPart1 and so on. I have the code in place to check this. Once the last record is verified the form moves to a new record on the form (record 2 of 2 at the bottom). My issue is that it is possible to run out of components to build so an operator may only scan in 1, 2, 3, or 4 out of the 5 labels until the next day when more parts arrive.
So l will need the form to re-open to the records that were not completed. I will use Spart1 field as an example. What I did was create the following in the Open Event on the form which is not working.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.findfirst "Isnull ([Spart1])"
Me.Bookmark = rs.Bookmark
Me.Spart1.SetFocus
When I open the form it always seems to go to the first set of records on my form wich is already completed. Also I need to know how to incorportate the null fields in an if statement since it is possible to have either the 1st, 2nd, 3rd, or 4th fields of Spart blank. Or if someone can give me a better code route to pursue that would be great.
Start Free Trial
