Side by side form?

Question

Good afternoon -

I need to create a data entry form in Access. One one side of the form I want to display information that will not be changed from a query of two tables joined by a unique ID. On the other side of the form I want the user to enter responses to a number of questions presented to the unique ID. Easy enough to display the information I already have and not allow edits but how do I allow data entry for the responses?

Form needs to be side-by-side because the questions to be asked are related to the (static) information displayed. Haven't used Access in quite a while and I'm drawing a blank how to do this.

Thank you.

Answer 1

Thank you! I will give this a try.

Answer 2

Every Control has Locked and Enabled properties. So it is easy to set some controls as locked (not allowing focus) and others to allow entries.

However, in your case, the answers to your questions should be stored in a separate table. so you should be using a subforn to enter the answers.

In fact, a questionnaire application requires a very specific base structure. Ken's sample illustrates a more complex version of of it. The base structure should look like this:

tblQuestions: QuestionID (PK), Question

tblRespondent: RespondentID (PK), First, Last, other info about Respondent

tblResponse: ResponseID (PK), RespondentID (FK), ResponseDate

tblAnswer: AnswerID (PK), ResponseID (FK), QuestionID (FK), Answer

This structure can be expanded on as needed. But this is the minimum.

Answer 3

Thank you for the quick response!

I will take a look and see if it meets this particular task's needs.

Answer 4

You might like to take a look at Questionnaire.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

This little demo file  allows you to create questionnaires in which the questions are presented in a list box in the left side of the form, and the answer(s) to each selected question are entered in a subform on the right of the form.  The physical model for the database is as below:

 ![](https://learn-attachment.microsoft.com/api/attachments/60d6ecf4-b4fc-444e-acef-e893bc2d4e7e?platform=QnA