How do I move a selected record, if a checkbox is checked, to determine whether the record needs to move to another table or not? I need to completly move certain checked records to another table. Scheduled Wkstn-Users is the table/form I am selecting a checkbox from, so i can determine whether or not the record will move from Scheduled_Wkstn-Users to Migration_Complete? I am not sure exactly how to get this done. Basically, all in a nut shell, when i check a checkbox, then i need to run a query so that i can move all records, with all data/fields of that record, that are checked out of Scheduled_Wkstn-Users to Migration_Complete. Any help would be much appreciated!!! 🙂
This is what i have for the sql part.
INSERT INTO Migration_Complete
SELECT *
FROM [scheduled wkstn-users]
WHERE chkMigrationComplete.value=true;
Also, I havn’t figured out yet what to put in the code for the checkbox.
THANKS AGAIN FOR ANY HELP ON THIS!!! 😉
