Having some problems trying to populate my Array. Heres the code...
Sub LoadArray()
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim avarRecords As Variant
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("SELECT ID FROM TABLE1 WHERE ID < '10'")...