Default Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

transfer data between forms using Macro and VBA 1
Populate 'To' recipient on custom mail form 0
Return values based on 1st column 0
Conditional Formatting - I just don't see what I'm doing wrong. 3
Can't assign a value ... 5
lookup question 1
Pulling data into a form and making it save 7
Can't assign value error 2

Back
Top