I am trying to write code on a command button that will move through a specified table record by record preforming action based on data found in the table. I am just unsure of what syntax to use. These are the exact operations im trying to do written in psudocode:

1. maximum = Table.ScheduleTime.Count#ofRecords

2. for(index to maximum)
         If(Table.ScheduleTime.index.Time = "9:00AM" Then

***scheduletime is the name of the table
***index is the record we are on
***Time isthe value in the record im testing against

Should be something like:

    Dim wrkDefault As Workspace
    Dim dbs As Database
    Dim rst As Recordset
    Set wrkDefault = DBEngine.Workspaces(0)
    Set dbs = CurrentDb
    Set rst = dbs.OpenRecordset("scheduletime")
    Do While Not EOF()
       With rst
            if Time = "9:00AM"
               ...
            end if
            .MoveNext
        End With
    WEnd
    ...
    dbs.Close


Hope this helps.



[LGuzman]