I am trying to create a form from questions listed in a table, add a yes/no column to it and then have it auto populate a data sheet with the question and the answer. Anyone have any suggestions how I can have the datasheet autopopulated?
I am trying to create a form from questions listed in a table, add a yes/no column to it and then have it auto populate a data sheet with the question and the answer. Anyone have any suggestions how I can have the datasheet autopopulated?
You have to create records in a table. You need a table that has unique key value of the question (or the question itself) in one field and a Yes/No field and some other ID (applicant, employee, ?) to base filtering on. Creating this set of records will require use of code and sql INSERT action.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.