Access Forms How Do I...

This page links to help on widely used form-related tasks. To view other categories of popular tasks covered in Help, see How Do I... in Access.

User Input

• How to: Add a Value to a Bound Combo Box

  • Describes how to add a use the NotInList event to add a new value to a bound combo box.

• How to: Determine Whether The Current Record is a New Record In a Form

  • Illustrates how to use the NewRecord property to determine if the current record is a new record.

• How to: Display a Custom Dialog Box When the User Deletes a Record

  • Describes how to use the BeforeDelConfirm event procedure to display a custom dialog box when the user deletes a record.

• How to: Perform Simple Data Validation Checks When Editing a Record in a Form

  • Describes how to use the BeforeUpdate event of a form or a control to perform validation checks on data entered into a form or control.

• How to: Prompt a User Before Saving a Record

  • Describes how to ask a user for confirmation before saving a record.

• How to: Use Numeric Criteria from a Control on a Form

  • Describes how to specify numeric criteria coming from a control on a form.

• How to: Use Textual Criteria from a Control on a Form

  • Describes how to specify textual criteria coming from a control on a form.

• How to: Use User Input to Build Filter Criteria

  • Describes how to build criteria based on user input.

Controls

• How to: Add "(All)" to a Combo Box or List Box

  • Describes how to add an (All) entry at the top of a combo box.

• How to: Allow Users to Add Items to an Unbound Combo Box

  • Describes how to use the NotInList event to add a new value to an unbound combo box.

• How to: Assign a Control a Value From a Table

  • Describes how to use the DLookup function to display the value of a field that is not in the record source for your form or report.

• How to: Call Procedures in a Subform or Subreport

  • Describes how to call a procedure that is stored in a subform or subreport form the main form or report.

• How to: Hide a Subform if the Main Form Contains No Records

  • Describes how to hide a subform when its main form contains no records.

• How to: Prevent the Accidental Erasure of Data When Moving Between Controls on a Form

  • Describes how to avoid erasing data accidentally when moving between controls.

• How to: Refer to Tab Control Objects in VBA

  • Describes how to use tab controls on a form.

• How to: Set Form, Report, and Control Properties in Code

  • Describes how to set properties of forms, reports, and controls.

Design

• How to: Apply a Custom Ribbon to a Form or Report

  • Describes how to display a custom ribbon when a particular form or report is opened.

• How to: Bind a Form to an ADO Recordset

  • Describes how to set a form's Recordset property to an open ADO Recordset object.

• How to: Create a DAO Recordset From a Form

  • Describes how to create a Recordset object based on an Access form.

• How to: Create Multiple Instances of a Form

  • Illustrates how to open multiple copies of the same form.

• How to: Synchronize a DAO Recordset's Record with a Form's Current Record

  • Describes how to synchronize a recordset's record with the form's current record.

• How to: Synchronize Two Combo Boxes on a Form

  • Describes how to limit the choices in a combo box when selecting an item in another combo box.

• How to: Use Date and Time Criteria from a Control on a Form

  • Describes how to change the criteria argument for an operation based on a user's decision.

Events

• How to: Apply a Filter When Opening a Form or Report

  • Describes several techniques for filtering a form or report as it opens.

• How to: Cancel an Event

  • Lists the events that can be canceled programmatically.

• How to: Cancel the Deletion of a Record by Using Custom Criteria

  • Illustrates how to prevent the deletion of a record based on custom criteria.

• How to: Change the Filter or Sort Order of a Form or Report

  • Describes how to change the filter or sort order of a form or report in response to users' actions.

• How to: Disable PAGE UP and PAGE DOWN Keys in a Form

  • Illustrates how to use a form's KeyDown event to disable the use of the PAGE UP and PAGE DOWN keys in the form.

• How to: Prompt a User Before Closing a Form

  • Describes how to ask a user for confirmation before closing a form.

• How to: Suspend Code Execution Until a Pop-Up Form is Closed

  • Describes how to use the OpenForm method to suspend code until a pop-up form is closed.

Printing

• How to: Programmatically Retrieve Printer Capabilities

  • Describes how to use the Microsoft Windows API to determine a printer's capabilities.

• How to: Retrieve a List of Installed Printers

  • Describes how to use the Printers collection to determine the installed printers.

• How to: Work with Form and Report Printer Settings

  • Describes how to set or retrieve printer settings for a specific form or report.

• How Do I... in Access