O'Reilly logo

Microsoft Office® Access 2007 Inside Out by John Viescas and Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 us, 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 Conrad Systems 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 20-24 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required