[RESOLVED] How to set current date..??

[RobDog888]

No, you cant just do a .MoveNext without evaluating which record the recordset is on.

rst.MoveFirst
Do While rst.EOF = False
    If UserForm1.txtQty.Text = rst.Fields("Item_Code").Value Then
        Exit Do
    End f
    rst.MoveNext
Loop