OK, I have a table Im moving data from into another table via SQL
INSERT INTO ...... FROM ..... VALUES on a mouse click. I want to "tag" that record so as not to use it again in a different table. I do not want to delete it. I added another field called select and made it a yes/no. How can set that particlular fields property to 0 or -1 (yes/no) after I have done the above code.
I have tried every combination of
table1.select =
list0.column(3).value =
and everything inbetween.
Ultimately I will do an if, select case to check this value before the SQL but I think I can handle that.
BTW, Im doing all this movement via list boxes bound to each table
Thanks
INSERT INTO ...... FROM ..... VALUES on a mouse click. I want to "tag" that record so as not to use it again in a different table. I do not want to delete it. I added another field called select and made it a yes/no. How can set that particlular fields property to 0 or -1 (yes/no) after I have done the above code.
I have tried every combination of
table1.select =
list0.column(3).value =
and everything inbetween.
Ultimately I will do an if, select case to check this value before the SQL but I think I can handle that.
BTW, Im doing all this movement via list boxes bound to each table
Thanks
