Default Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JS - 20 Jun 2007 12:22 GMT

I have a form that has fields about customers. I'm trying to automate a
couple fields using conditions in a macro.

In the City field, if a person enters "Cleveland" I want the Region field to
populate "OH" and the Country field to populate "US". Is this possible using
conditions in a macro?

Thanks!

Reply to this Message

Marshall Barton - 20 Jun 2007 14:12 GMT

>I have a form that has fields about customers. I'm trying to automate a
>couple fields using conditions in a macro.
>
>In the City field, if a person enters "Cleveland" I want the Region field to
>populate "OH" and the Country field to populate "US". Is this possible using
>conditions in a macro?

That kind of thing is usually dealt with by using a series
of dependent combo boxes
http://www.mvps.org/access/forms/frm0028.htm

Signature

Marsh
MVP [MS Access]

Reply to this Message