Help with code

[sfrope1]

I have a code that contains
For X = intNumberOfSlots To 1 Step -1
rsExists.Open "SELECT * FROM Registration WHERE EventID = " & Me!EventID & " and RopingOrder = " & X, CurrentProject.Connection, adOpenStatic, adLockReadOnly
If rsExists.RecordCount = 0 Then
intBestSlotNo = X
rsExists.Close
Exit For
End If
rsExists.Close
Next X
When I run this command button I get a error compile error
variable not defined and it stops at the For X. Can someone help me with this code?

 

[mas5]

Have you declared the X variable at the beginning of your procedure? If you use Option Explicit, then you must declare all of your variables.

You need Dim X as Integer (or Long depending on how big the number is.)

 

[sfrope1]

Thank you, that made it work great