Check box question

[Richard]

On my form I have a check box named "Called†when I click the box I have code
in the click event to move to the next record and this work great...

Private Sub Called_Click()
If Me.Called Then
If Me.Dirty Then Me.Dirty = False
DoCmd.GoToRecord , , acNext
End If
Me.Requery
End Sub

Question: when I open the form I would like it to go to the next record that
does not have a check in the "Called" Field. I don't want to hide the
checked records just start at the next unchecked record. I hope this makes
sense.

Richard

 

[Steve Schapel]

Richard,

One way of achieving this would be to base the form on a query, in which you
sort by the Called field Descending.

By the way, I would recommend using the After Update event rather than the
Click event for that code.

 

[Richard]

Thanks for your suggestions, I am not sure why I didnt put the code in the
after update to begin with. As for your advice on sorting it does work, it
puts all the records "with a check" at the end of the of the list so it does
keep them out of my way.

Richard