Hi all!

I'm using a grid whose record source is a view to collect data. I'm trying to save the changes a user makes in column2 back to the original table by using code in the LostFocus method of the textbox under the column2.

My code (which isn't working of course) looks like this (again, it's grid->column2->text1's LostFocus method):

local lview, lswid, lver
*the following 3 lines capture the current view record data to use
* as a filter in the original table
lview = this.parent.parent.recordsource
lswid = &lview..software
lver = &lview..version
*select the original table, use a filter to access the correct
* record and replace 'version' field with the value in the
* current grid-column-textbox
select software
set filter to acode=caid and hwid=chwid and software="&lswid" and version="&lver"
go top
replace version with this.value

Any clue what I'm doing wrong? Similar code is working for my combo boxes but for a 'simple' text box, this isn't working.

MTIA!
Mandy