Recording the first ID number in a table as a variable

[gal4y]

I would like to capture (record) the first records ID number (which starts with 1830) so I can use it with arrays. The ID number is a field in my Score table. How do I record that first ID number as a variable (StartID)??

Dim db As Database, rs As DAO.Recordset
Dim SQLString As String
Dim StartID as Integer

Set db = CurrentDb
Set rs = db.OpenRecordset("Score&quot

StartID =????

Thank you for your assistance in advance
Greg

 

[Durkin]

If you mean the lowest ID number in the table use SELECT MIN(IDNumber) FROM Table.

Durkin