Hi Peter,
Not sure what the problem is here. However, have you considered using a combobox in column1 instead of a textbox? This way the user can only pick valid invoice numbers.
>IF NOT SEEK(THIS.VALUE,"Invoice","Invoice_no")
> TABLEREVERT(.F.,"Payments")
>ENDIF
>
>This code is attached to the valid method of grdInvoice.Column1.Text1
>
>There are one or more rows above the active row.
>
>All rows in the grid show up empty, Payments table hits EOF, and no amount of GO TOP IN Payments followed by refreshing the grid or the entire form for that matter will show the data.
>
>Debugging does not get me anywhere, ´cause during debugging this does not happen.
>
>Am at my wits end, and any and all suggestions are appreciated.
>
>Regards
>
>Peter
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.