How to select field from first row where a variable is unticked

[LWCARAB]

I have a table with contains issue numbers and a tick box to say whether or not it has been published.
I need some code that will go through the table and find the first number which is unticked to that I can use that issue number.

THanks,

Richard

 

[KenHigg]

Hum... Sort or use a parameter query? Or maybe even a dlookup()?