05 – Forms

In this post we will be taking a look at forms and how you can use them in your Access applications. Forms represent the central way in which data can be added to your Access applications and in order to master Access, you will need to have a very good understanding of the way they work. We will be covering topics such as Formatting, Bound/Unbound forms, Sorting, Filtering and Multiple item forms.

List of topics covered:

  • The Anatomy of a Form
  • Basic Form Formatting
  • Formatting the Header, Detail and Footer
  • The Detail Section – Single and Continuous Forms
  • The Form Object, Bound and Unbound Forms and Controls
  • Record Source
  • Bound and Unbound Summary
  • Continuous Forms and Record Navigation
  • Sorting in Forms
  • Filtering in Forms
  • Creating Forms
  • Form Generator
  • Split Form Generator
  • Multiple Items Forms Generator
  • Custom Form Designer
  • Other Form Types
  • The Data Entry Property
  • Sub Forms
  • Master Fields: Child Fields
  • Introducing TempVars
  • Lifespan of TempVars
  • Example of TempVars
  • Opening Forms with the “Where” Clause

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.

In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!