Books Table with 5 fields: 1 is autonumber, 3 text fields 1 number field
fields autonumber,Title, First, Last, AuthorID

My form has txtboxes with data
txtTitle,txtlast,txtfirst,txtAuthorID

this works to insert a record with any of the fields if only one field is used.  

db.Execute "INSERT INTO Books (txtFirst) VALUES ('Rex');"

  ' this adds a record with Rex in the First field.

db.Execute "INSERT INTO Books (txtAuthorId) VALUES (55);"  '  adds a record with 55 in AuthorId field

I can't do this
db.Execute "INSERT INTO Books (Title) VALUES (txtTitle,txtLast);"  

what is the syntex to Execute "insert   txttitle,TxtLast,TxtFirst,TxtAuthorId into table books?

Thanks for any help I'm just a 78 year old retired guy that likes databases.