Default Value

J

JS

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!
 
M

Marshall Barton

JS said:
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?
Click to expand...

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