Cannot create blank fields in auditing database

[robslackjr]

I am new to MS Access and am trying to create an audit database. This database creates audits comprised of a series of questions. Each question is associated with a number of attributes, including process area and weighting. I am having trouble creating forms that create a set of blank questions.

Table Structure

The db centers on three primary tables:

Audits - Provides an index of audits that have been conducted.

• PK
• Date of audit
• Name of auditor

Audit questions - Provides an index of each question in the assessment; this table also associates various attributes (such as weighting) from secondary tables.

• PK
• Weighting
• Process area
• Other attributes
  

Results- Contains the data for individual audits.

• Primary key
• audit fk
• question fk
• Results
• Findings,
• Observations, etc.

Form Structure

I have created a form based on the audits table. I have added to this form a subform based on a query that combines questions and data. This query allows me to see the questions that have been already been answered along with the answers.

Description of Problem

I need this form to be able to (1) create a new assessment and then (2) populate a fresh set of blank questions. I am able to review already conducted audits but I cannot figure out how, within this structure, to show the end user the entire set of questions that need to be filled out.

I have been floundering with the problem for a couple of days and can't figure out if the solution is a matter of creating a macro that both creates a new assessment and appends data into the results table, of if it's a matter of better querying and/or form design.

(I will also need to figure out how to implement the appropriate data validation to assure that all fields are populated--but I think I can muddle through that issue on my own...)

[June7]

You need to create records in the Results table. Then present this set of 'blank' records to the user for completion of other data. Can use an INSERT SELECT sql action to accomplish. Here is one example https://www.accessforums.net/program...nts-26223.html