placement of .movefirst and .movenext

[Ruegen]

i have this code

Option Compare Database

Private Sub Form_Load()
With Me.Recordset


Do Until Me.ID = 24855


.MoveNext


If txtBonusID = "CJW" Then
txtBonusID = "3"


ElseIf txtBonusID = "lpc" Then
txtBonusID = "5"


ElseIf txtBonusID = "ke" Then
txtBonusID = "4"


ElseIf txtBonusID = "els" Then
txtBonusID = "8"


ElseIf txtBonusID = "ra" Then
txtBonusID = "1"


ElseIf txtBonusID = "wp" Then
txtBonusID = "7"


ElseIf txtBonusID = "wsp" Then
txtBonusID = "7"


ElseIf txtBonusID = "akb" Then
txtBonusID = "2"


ElseIf txtBonusID = "ss" Then
txtBonusID = "6"


End If




Loop
End With
End Sub

However it doesn't start from the first record in the query - it skips the first and does the next so I know I have the placement of .movenext - I would love to know where to put it and where to place .movefirst so that it starts at the first record and then flows through the IF with each record with .movenext

[pbaldy]

The MoveNext should be right before Loop.

[Ruegen]

The MoveNext should be right before Loop.

duh me, of course!

I am planning on getting a brain transplant today... should fix things.

Thanks pbaldy!

[pbaldy]

No problemo!

[Missinglinq]

...I am planning on getting a brain transplant today... should fix things...

Perhaps removing those things from your ears might help!

[Ruegen]

Perhaps removing those things from your ears might help!

lol

I tried, oh how I tried...