call routine from form change

[timp]

I want to run a routine to fill in a custom field
whenever a certain address field is changed in a new
contact item (or entered for the first time). I think I
need to call an application-level routine because it's
too complicated to code in the form.

How can I call this routine when a form field changes?

Thanks for any help

P.S. I'm reasonably OK with writing VBA code, but new to
writing scripts in forms.

 

[Hollis D. Paul]

How can I call this routine when a form field changes?

Thanks for any help

P.S. I'm reasonably OK with writing VBA code, but new to
writing scripts in forms.

You would just put a call statement to your VBA routine in the field
change event when your field changed. Look for code examples on
www.slipstick.com. Try the following
page:http://www.slipstick.com/dev/propsyntax.htm

The problem with this approach is that there are no good ways to share
this code with other users. You really want to do it as an Add-in, for
which you can build an install package.

See http://www.outlookbythesound.com/prod02.htm, where I have a custom
toolbar as a VBA project, VB6 project, and as an Outlook Add-in.



Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA