I understand that I can insert a record into a table such as:
DoCmd.Run SQL "INSERT INTO tblName ([Fname],[Lname],[Bday]) Values ('Martin', 'Green', #09/27/1950#);"
However I do have a LOT of fields in the span of a 2 page form. How can I do it so that all fields are inserted in table as a record. Thank you!!
DoCmd.Run SQL "INSERT INTO tblName ([Fname],[Lname],[Bday]) Values ('Martin', 'Green', #09/27/1950#);"
However I do have a LOT of fields in the span of a 2 page form. How can I do it so that all fields are inserted in table as a record. Thank you!!