display form fields based on data entry
Posted on 2009-04-29
Objective: Create automated MS Access 2007 form that adjusts based on data entry.
We are trying to create a data entry form to store data and print reports on our clients. Not all people are married or have children, thus we want to form to adapt to each individual case.
Two fields to start with: Client_Name_Field Is_Married_Checkbox
If married, then display new field Spouse Name field and Children_checkbox
If children, then display field Child Name field and [additional_children_checkbox1
If additional children, display Child2 Name Field hide additional_children_checkbox1 and display additional_children_checkbox2