First of all. Ive created 2 tables
book and borrowed (table)
title,author (both have the same fields)
IN the form of book, theres a "borrow" (command1) button wherin when i press it, the data of the fields (title and author) will go to the table borrowed...
please revise my coding which sucks
Private Sub Command1_Click()
DoCmd.RunSQL = "INSERT INTO borrowed (Author,Title) VALUES (" & Me!Author & ", " & Me!Title & ")"
End Sub