i have 4 textboxes in my form whose controlsource are leave.empno, leave.type, leave.frdate and leave.todate.

i also have an ADD button with append blank. i have a separate SAVE button which does the =tableupdate(.t.)

leave.type is 1 character so when i enter say "X" cursor moves on leave.frdate.

if say for example i have entered "X" when i should have entered "Y", i use the up arrow key to move cursor to leave.type.

cursor moves but my problem is when i do this, value of leave.type changes to the first record of the table leave. if i press up arrow key again, leave.empno changes to the first record of the table leave again.

how can i avoid this? should i just trap the up arrow key? but i want my users to be able to move in the textboxes while in the append mode using the arrow keys.

pls advise. TIA.