'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Create a Side-by-Side Data Entry Form in Microsoft Access
Question details
The user needs to create an Access form that displays read-only reference information on one side and provides editable fields for data entry on the other.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Building a questionnaire or data entry interface that requires users to read static information from one table while inputting answers into a related table simultaneously.
- Observed behavior
- Requires a method to lock certain fields in a joined query view while keeping answer fields editable, ultimately storing responses properly.
Ensure your underlying database tables are properly normalized with correct primary and foreign keys (e.g., separate tables for Questions and Answers) before building the form interface.
Configure Control Properties and Use a Subform
By modifying the Locked and Enabled properties of your form controls and utilizing a subform layout, you can seamlessly separate read-only reference data from editable entry fields.
A standard joined query can sometimes render an entire recordset uneditable in Access. To solve this, base your main form on the read-only information table and use a linked subform for data entry, or apply specific field-level locks on a single continuous form.
Create separate tables for your reference data (e.g., 'Questions' table) and your data entry (e.g., 'Answers' table), ensuring they share a relational key.
Use the Form Design tool to create a main form bound to your read-only table or query. Place the necessary text boxes for the information you want displayed.
Select the text boxes containing the reference data. Press F4 to open the Property Sheet, navigate to the Data tab, and set the 'Locked' property to Yes. Set 'Enabled' to No to prevent clicking, or Yes to allow users to copy the text.
From the Design tab in the Ribbon, select the Subform/Subreport control and draw it onto your main form alongside the locked fields. Bind this subform to your editable 'Answers' table.
Select the subform control, open the Property Sheet, and go to the Data tab. Verify that 'Link Master Fields' and 'Link Child Fields' are mapped to the correct primary and foreign keys so answers are saved to the right record.
Need a Lightweight Alternative for Everyday Office Tasks?
While WPS Office does not include a database management tool like Access, it serves as an excellent, free alternative for handling documents, spreadsheets, and presentations. Enjoy seamless compatibility with Microsoft formats, a familiar interface, and lightweight performance.
Frequently Asked Questions
Why can't I edit fields in an Access form based on a joined query?
In Microsoft Access, forms based on complex joined queries—especially those without a clear unique index or one-to-many relationship properly defined—become non-updatable (read-only). To bypass this, it is recommended to use a main form and subform combination to handle edits.
How do I make a text box read-only but still allow users to copy the text?
Open the form in Design View, select the text box, and press F4 to open the Property Sheet. Under the Data tab, set 'Locked' to Yes and 'Enabled' to Yes. This locks the field from changes while keeping it selectable.
What is the best way to structure a questionnaire database in Access?
It is best practice to use a normalized structure consisting of at least four tables: a Questions table (fixed reference data), a Respondents table (user details), a Responses table (the survey session), and an Answers table (the individual editable replies linked to both the question and the response session).
