saving edits to access from flexgrid

[aknighter]

I was wondering if anyone can help,

I have a flexgrid taking data from access by way of a data control. I have made code to make an invisible text box cover the cell and then the cell will take the text1.text after you change cells.

I can't seem to figure out how to save this edit to the database. Is it possible?

Thanks in advance,

aknighter

[Bigley]

You would save it exactly how you would save any other field update, by creating an update SQL string and executing it.

SO for example once teh user has left the floating text box and you update the cell you create the string

SSql = "Update table1 set fieldx = '" & TextFloat & "' where ........"
Then execute using whatever method you are using in your project be it DAO , ADO etc.