Microsoft Access 2010 Bible

Part III: More-Advanced Access Techniques

700

Finally, because ApplyFilter is triggered when the Remove Filter button in the Sort & Filter

group is clicked, you can use this event to reveal hidden fields, reset the Filter property to its

former value, and so on.

Filter event

The Filter event is similar to the ApplyFilter in that it’s triggered whenever the user invokes

one of the built-in form filtering options. The Filter event triggers before the ApplyFilter

event and is useful for displaying your own filtering form, removing controls that should not be

used in a filter by form session, and so on. Together the Filter and ApplyFilter events give

you a great deal of control over user access to the built-in filtering capabilities in Access.

Using the Tab Control

A tab control provides several pages, each accessed through a tab at the top, bottom, or side of the

dialog box. Figure 19.13 shows frmCustomers, a perfect example of a tabbed Access form.

frmCustomers contains a tab control with three pages, allowing the form to contain many more

controls than possible without the tab control. Each of the tabs along the top of the form reveals a

different page of the form’s data. Each page contains many controls. Figure 19.13 shows buttons,

labels, and text boxes. Each control on the page behaves independently of all other controls on the

form and can be accessed through Access VBA code as an independent unit.

FIGURE 19.13

The tab control allows a form to host a large amount of data.

As you might guess, the tab control is fairly complex. It includes its own properties, events, meth-

ods, and object collections. You have to know and understand these items before you can effec-

tively use the tab control in your applications.