Search un-used number

[Vincent Hadison]

Someone please help me to search unused number in mdb ordered number list
Eg:
From 1-10 I used these:
1
2
3
5
7
8
And unused these:
4
6
9
10
How can I search it?
Tx 4 ur help

[jggtz]

You could use a FOR-NEXT loop
and inside the loop lookup for the record for that number
Following your example:

FOR X = 1 TO 10
    Search your recordset with X
    If the search fails then is UNUSED else is USED
NEXT X

you didn't say if you're using ADO or DAO

[Vincent Hadison]

I am using ADO, thanks 4 ur answer, I will try it