Grid Data

[colin]

Hi All,

I have a grid which is populated with the contents of a table. This table is a waiting list for pending jobs. What I want to do is allow the user to select a row within the datagrid and then commit it.
I want to be able to move the record from the current table recordset to another table within the database which is identical but acts as jobs in progress.

Any Ideas ???

Colin

[Dman]

I did something like this but I moved it to a form first, edited it, then to another database. My rather patchwork suggestion would be to save it to an array then run an INSERT INTO to the next database. If you want to give the illusion of having moved it you'll need to delete it from the first database.

[colin]

Thanks Dman,

Will give it a try

Colin