how to update all records? 1

[Mandy_crw]

Hi everyone... may i ask help on updating my table using cursor.... i have cursor named CsrSms that has checkbox for multiple selection... and in my exit button i have the following codes...

 UPDATE sms SET special = CsrSms.special WHERE idnum == CsrSms.idnum

My problem is only the last record is updated even if ive chosen multiple checkboxes... I also used do while not eof ()

 DO WHILE !EOF()
	IF sms.grade == csrsms.grade
		UPDATE sms SET special = CsrSms.special WHERE idnum == CsrSms.idnum
	ENDIF 
	SKIP
ENDDO

but still only the last checkbox is updated... Please help.... Thanks