MS Access: Forms

Tutorials

TUTORIAL: Form Basics (Understanding and creating forms) in Access 2007 | Access 2003/XP/2000/97
TUTORIAL: Combo Box Basics in Access 2007 | Access 2003/XP/2000/97
TUTORIAL: Tab Control (Creating tabbed pages on a form) in Access 2007 | Access 2003/XP/2000/97
TUTORIAL: VBA Basics (Understanding the VBA environment) in Access 2007 | Access 2003/XP/2000/97
TUTORIAL: Debugging VBA Code (Understanding VBA's Debugging Environment) in Access 2007 | Access 2003/XP/2000/97

Navigation Pane (Access 2010 and 2007)

Display forms in the Navigation Pane in Access 2007
Display all objects (tables, queries, forms, reports, modules) in the Navigation Pane in Access 2007
Display tables and related objects in the Navigation Pane in Access 2007

Design

Display the form header in design view in Access 2007 | Access 2003/XP/2000/97
Display the form footer in design view in Access 2007 | Access 2003/XP/2000/97
Group controls in a form in Access 2007 | Access 2003/XP/2000/97
Ungroup controls in a form in Access 2007 | Access 2003/XP/2000/97

Formatting

Conditional formatting in Access 2007 | Access 2003/XP/2000/97
Change the background color of a text box based on whether a value has been entered in Access 2007 | Access 2003/XP/2000/97
Change the background color of a text box when the text box value changes in Access 2007 | Access 2003/XP/2000/97
Conditionally change the background color of a text box on a Continuous Form in Access 2007 | Access 2003/XP/2000/97
Center a form in the application screen in Access 2007 | Access 2003/XP/2000/97
Change AutoFormat (background style) for a form in Access 2007 | Access 2003/XP/2000/97
Set form colors to be consistent on different computers in Access 2007 | Access 2003/XP/2000/97
Set tab indexes in Access 2007 | Access 2003/XP/2000/97
Remove minimize, maximize, and close buttons from a form in Access 2007 | Access 2003/XP/2000/97
Picture as background of a form in Access 2007 | Access 2003/XP/2000/97
Define a custom format for a Date/Time field on a form in Access 2007 | Access 2003/XP/2000/97
Set up a text box to flash red/black when a date is past due in Access 2007 | Access 2003/XP/2000/97

Tab Controls

Establish tab order between objects in tab control pages in Access 2003/XP/2000/97
Set focus on first text box on first tab page and go to next record in Access 2003/XP/2000/97

Calendar

Popup calendar in a form/subform in Access 2007 | Access 2003/XP/2000/97

Subforms

Populate subform data automatically (one to many relationship) in Access 2003/XP/2000/97
Refresh the contents of a subform whenever the record in the main form changes in Access 2003/XP/2000/97
Display a particular subform based on a combo box selection in Access 2003/XP/2000/97

Combo boxes

Filter records based on a combo box selection in Access 2007 | Access 2003/XP/2000/97
Populate one combo box based on the selection of another combo box in Access 2007 | Access 2003/XP/2000/97

Startup

Automatically start up a form when database is opened in Access 2007 | Access 2003/XP/2000/97

Searches

Create a form where you can perform searches and display search results in Access 2007 | Access 2003/XP/2000/97
Create a form where you can search any text field in a table in Access 2003/XP/2000/97
Create a form where you can perform both text and numeric searches in Access 2003/XP/2000/97
Create a form where you can perform up to 3 search criteria that can be either text and numeric searches in Access 2003/XP/2000/97

Form's Close button

Disable Close button on a Form in Access 2007 | Access 2003/XP/2000/97
Enable Close button on a Form in Access 2007 | Access 2003/XP/2000/97

Miscellaneous

Check if a form is loaded in Access 2007 | Access 2003/XP/2000/97
Prompt for changes to be saved in Access 2007 | Access 2003/XP/2000/97
Use a control in an SQL statement in Access 2007 | Access 2003/XP/2000/97
Duplicate a record in Access 2007 | Access 2003/XP/2000/97
Refresh data in a form in Access 2007 | Access 2003/XP/2000/97
Redraw a form in Access 2007 | Access 2003/XP/2000/97
Update a text box to a value when a new record is created in Access 2007 | Access 2003/XP/2000/97
Prevent the mouse wheel from scrolling through records in a form in Access 2003/XP/2000/97
Set the background color of a button in Access 2007 | Access 2003/XP/2000/97
Disable the Esc key in a form in Access 2007 | Access 2003/XP/2000/97
Display on a form, the number of related records from another table in Access 2007 | Access 2003/XP/2000/97
Sort a form's records based on the value of a calculated field in Access 2007 | Access 2003/XP/2000/97
Load a form into memory, but do not display it in Access 2007 | Access 2003/XP/2000/97
Change the tab order on a form with VBA code in Access 2003/XP/2000/97
Replace system error message with a custom message in Access 2007 | Access 2003/XP/2000/97
Set the focus on the first field in a form whenever a record is viewed in Access 2003/XP/2000/97
Open a Form from another Form (disabling the parent form until the child form is closed) in Access 2007 | Access 2003/XP/2000/97
Set the value of a textbox based on the value of another textbox in Access 2003/XP/2000/97
Set up a text box to display the difference between two dates in Access 2007 | Access 2003/XP/2000/97
Add an independent label on a form in Access 2007 | Access 2003/XP/2000/97