Hi,
i have a problem defyning a loop in my application.
the situation is like this:
i'm making a calculation in acad that takes some numbers from a recordset in access.
the global thing should be something like this:
'calculation'
when X < Y then pick the next row of the recordset and make the calculation again with the new values.
when X > Y print text that values are sufficient.
the code i have right now looks like this.
it has some big flaws in it I think... could someone help me out on it?
would be great
Do Until rstobj.EOF
While Me.TextBox4.Value > Me.TextBox5.Value
rstobj.MoveNext
Loop
If Me.TextBox4.Value < Me.TextBox5.Value Then
MsgBox "calculation ok"
End If