I am trying how to use a value entered in an input box or a textbox on a form.
The loop will continue to check the checkboxes on this form until it reach the value in the text box (or better yet I should use an input box).
This is the sql statement I want to next inside a loop that will continue to check boxes on this form until the value in the textbox or input box is reached..
UPDATE Students SET Students.[Update] = Yes
WHERE (((Students.Update)=No) AND ((Students.FlightPath)=[forms]![SCHEDULER]![cboFlightPathList]) AND ((Students.Code)>=5));
I am sorry but I do not have clue where to start.
Please help