Automating Complex Tasks

The most complex Visual Basic code we’ve examined thus far in this chapter is the procedure to build a search clause from the data you enter in the fdlgContactSearch form. Trust me, we’ve only started to scratch the surface!

Triggering a Data Task from a Related Form

One of the more complex pieces of code in the LawTrack Contacts sample database is triggered from the fsubContactEvents form that’s part of the frmContacts form. After signing on correctly to the application, the user can open the frmContacts form, click on the Events tab, and add an event indicating the sale of a product. As soon as the user saves the record, code behind the subform automatically adds the product to the contact, as shown in Figure 23-24.

Figure 23-24. Logging ...

Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.