Hi!

Never use the Value property of the control inside of the grid for validation rules outside of that control. Only focused control in grid have correct value. Other controls are used to refresh grid, so value property changed for each row in visible portion of grid. This means that you cannot tell exactly what it will be. It may be also always zero in case EOF reached (grid shows the rest of records). Instead of "thisform.grid.column.textbox.value" use "MyAlias.MyField".

>I have a grid with a recordsource of 5 records & no relations. looking at this in the debug mode the controlsource value shows correctly but thisform.grid.column.textbox.value shows zero. I test for the value, if zero a message to input a value shows. My problem is, a value is input but i am in a loop with the error message. I am having trouble understanding why the value displays in the grid but does not show in the value property of the textbox.
>the table is buffered and tableupdate has been done.
>Any ideas?