How To Detect If A Field Is Changed In A Form In Access

Different ways to open an Access course using DoCmd.OpenForm

A form has many properties that determine its behaviour. These properties concern the mode information are presented, possible filters, how information technology tin be used to enter of edit information etcetera. When you design your class, that is the fourth dimension you will make up one's mind on the defaults for your form. However you may want to utilize roughly the same form in dissimilar ways. A powerful way to change from the blueprint-time default behaviour is using the DocDmd.OpenForm arguments.

OpenForm with FormName

The simple way to open a form is by supplying the FormName and keeping all the defaults.

          DoCmd.OpenForm FormName:="Customer"

When opened this mode Access interprets the command with defaults as here:

          DoCmd.OpenForm FormName:="Customer", View:=acNormal, DataMode:=acFormPropertySettings, WindowMode:=acWindowNormal

OpenForm View

The most common ways to open a form are every bit Grade (acNormal) or equally datasheet (acFormDS). Special View modes which can simply exist fix in design time are Split form and Continuous class. A split form tin be useful if the user wants to easily navigate betwixt records and at the same time make changes to the data. More info: Create a split form. A continuous grade is used when a datasheet is insufficient.

Other view modes are acFormPivotTable and acFormPivotChart. For more than info see Programming Pivot Tables for Access Forms

Data mode

If yous leave the DataMode argument blank the default constant, acFormPropertySettings, is assumed. This opens the grade in the information mode set by the grade'due south AllowEdits, AllowDeletions, AllowAdditions and DataEntry properties.

The other possible DataMode values are:

acFormAdd - which opens the form on a 'new' (empty) tape allowing the user to create a new record.
acFormEdit - shows the contect of the current selected tape and allows editing.
acFormReadOnly- no adding or editing immune.

OpenForm WindowMode

The default value acWindowNormal shows the form as normally washed in Access. Using acDialog causes the course's Modal and PopUp backdrop to be prepare to Yes. With acDialog your calling code should not proceed until the form is closed.

OpenForm using FilterName

FilterName refers to a query in the current database. You tin can use either an existing query or a filter that was saved as a query. You lot tin can use it both for getting a subset and for having information technology sorted.

OpenForm WhereCondition

A valid SQL WHERE clause (without the word WHERE) to select records from the form's underlying table or query. If y'all select a filter with the Filter Name argument, Access applies this WHERE clause to the results of the filter.

To open a course and restrict its records to those specified by the value of a command on another form, use the following expression:

[fieldname] = Forms![formname]![controlname on other form]

Supervene upon fieldname with the proper noun of a field in the underlying tabular array or query of the class you want to open. Supplant formname and controlname on other grade with the proper noun of the other form and the control on the other form that contains the value you want records in the first form to match.

OpenForm OpenArgs

OpenArgs gives an opportunity to pass data to the form which information technology and then tin choice up in the Form_Open effect. Example of how to practise that can be found here.