Originally Posted by
welshmpf
Do you think the repeat expresion is still checking the record i am on and not the next
Like I said, yes, unless you're changing the record with focus via GoToRecord or something like that. I would tend to work "behind the scenes", not on the form. This type of thing:
Code:
Dim strSQL As String
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb()
'this would be an SQL statement that retrieved the records that needed to be worked on
strSQL = "SELECT * FROM TableName WHERE Whatever"
Set rs = db.OpenRecordset(strSQL, dbOpenDynaset)
Do While Not rs.EOF
'your process here to modify those records, likely via the Edit method of the recordset
rs.MoveNext
Loop
set rs = nothing
set db = nothing