Forms for Data Entry

Why Forms

Datasheet grids are fine for maintenance, but users need friendly entry screens. A form shows one record at a time with labeled boxes, lists and validation.

Create a Form Fast

Select a table/query → Create → Form - Access builds a working form in seconds. Edit it in Layout view; fine-tune in Design view.

Form Controls

• Text box - bound to a field for typing.
• Combo box - a dropdown; bound to a lookup (choose a Customer ID by name).
• Check box - Yes/No fields.
• Subform - embed related records (orders under a customer).
• Command button - Save, Next, New (the wizard builds the VBA).

Form and Record Navigation

• The record bar at the bottom moves between records: Next, Last, search.
• Use the Form Wizard (Create → Form Wizard) for multi-table forms with subforms.
• Set Allow Additions/Deletions and Data Entry (new records only) on the form properties.

Layout vs Design View

Layout view edits while seeing live data; Design view gives pixel-level control. Do most work in Layout view.

Key Points

• Forms present one record nicely; datasheets handle bulk work.
• Comboboxes prevent typing mistakes by offering valid choices.
• Subforms are how you show parent + children on one screen.