form to store notes

[Mike Hughes]

I have a federal audit coming up and to assist me in answering questions I created a DB to collect the data which will be questioned.
The DB has a form I'll call the MAIN FORM. This consoldiates case data in one place for easy access. Each case has a unique identifer field "NO" (for number). I have the form working great.

As the auditor asks question about each case I would like to have the ability to store the questions and my responses in this DB. I'm just not sure the best way to do this.

If I'm on the MAIN FORM and the auditor has a question about one of the cases, I would pull up that case on the MAIN FORM and then I would like to have the ability to store that question for that case somewhere so that I can view all the questions for that case at a later date. Besides the questions I would also like to store the date and time it was entered.

I was thinking about something like a button on the MAIN FORM to open a table or another form where this information could be entered and stored. I'm just lost on how to do this.

I have attached a screen shot of the MAIN FORM if that will help. Thanks

 

[missinglinq]

This is really the classic one-to-many relationship scenario which is usually done using a Main Form (as you already have) with a Sub Form. The Form to be used as the basis for the SubForm would have the Case Number, DateAsked Question and Answer field. Add a subform to your Main Form, using the Wizard, and Access will ask what field to use to link the Form/Subform. Use the Case Number. And that's pretty much it. As you move from one case number to another, on the main form, the subform will do likeweise. You can enter a new question/answer for any given case number.