Goto next record where X checkbox field = null

[Range]

I've created a database for multiple users to work from.

Basically a list of work cases is entered into the database at the start of the day. The fields are;

Reference (Text)
Work List (Text)
Received Date (Date)
Reference worked (Checkbox [yes/no])
Date Worked (Date)
Employee (Text)

Then multiple users work references on an AutoForm of the above table, completing each record. The problem is they have to manually find the next record where checkbox is null

Is there anyway where each individual can just GoTo Next record where the "Reference Worked checkbox = null" using some sort of Vb code in a command button

Many Thanks

 

[xenou]

You should be able to filter the form to show only Null records. This could be coded into the form's record source as part of the SQL, or as part of a filter. Incidentally, you could also apply the filter or release it, if it were part of a filter. And in fact I would think a user could filter the data this way on the fly using the record filtering tools (buttons or menus).

HTH,
ξ