I am just learning VBA thru online.. and I couldn't find a solution.
I got these code
CurrentDB.Execute "INSERT INTO Table1 SELECT * FROM Table2 WHERE AppID = " & Me.AppID & ";"
but the problem is all the data in other table will be copied. what I only want is a single row with all the columns will be copied with respect to the checkbox I checked. I am designing that every row has its own respective checkbox.
Thanks!