I have a form with the following code for deleting a record:
if messagebox("Are you sure you want to delete this user ?",4+32+256,"** Confirm User Deletion **")=6
select sysusers
zrecord = recno()
delete
zrecord1 = recno()
skip
zrecord2 = recno()
if eof()
go bottom
endif
endif
thisform.disabledata()
zrecord3 = recno()
thisform.refresh()
zrecord4 = recno()
save to zzz all like z*
When I delete record 3 (in a table of 22 records), the values of the memory variables I created to determine the current record are as follows:
zrecord: 3 - this is correct
zrecord1: 3 - this is correct
zrecord2: 5 - this is correct
zrecord3: 5 - this is correct
zrecord4: 23 ??? (the last record is 22)
There is no code the refresh method of the form.
Why is the value of zrecord 23?
Al Williams
Anola MB, CANADA