General information
Category:
Forms & Form designer
Title:
Saving grid data back to original table
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only