Can someone tell me/show me how to reference a table please?
I have a table, tbl_ExerciseID, within it there are two coloums ID and Merged. ID is the ExerciseID and Merged is a Yes/No checkbox. I want to put this on a form. So I have eight boxes and one or all of them can be ticked and the data saved to the table. i.e ID1 can have a check mark next to it in the table and so on. I think it should be done through a recordset but I have not worked with them before, (at least not knowingly) I'm at a loss!
I have a table, tbl_ExerciseID, within it there are two coloums ID and Merged. ID is the ExerciseID and Merged is a Yes/No checkbox. I want to put this on a form. So I have eight boxes and one or all of them can be ticked and the data saved to the table. i.e ID1 can have a check mark next to it in the table and so on. I think it should be done through a recordset but I have not worked with them before, (at least not knowingly) I'm at a loss!