How can I make my appendquery put the data in the next record. Right now when I run my append query it places data at the end of the first record.
I have 3 tables: RevTbl(Reviewers table this is for the person inputting info)
Questbl: the indexed question numbers and the actual question.
AnswTbl: this is the output for the query
I have an input form: RevFrm this is designed to input person info and after the query is run, Anwsubfrm input the answers to each question.
right now when I run the query the first record is great, the I go to the next record in the RevFrm run the query and the info is appended to the first record of the AnswSubform. How can I get it to append to the AnswSubform in the next record?
I have attached the databaseChecklistDB.zip