Hello,
I'm working on a form--a portion of which has two fields:
City:
State:
I'd like to write some VB code that would automatically fill the state field when the user enters a common city in the city field. I have a separate table with the same two fields and records like this:
1 Boston MA
2 Springfield MA
3 New York NY
etc. I'd like to use that table as the reference (the brains) driving the auto state completion task.
I've been using BeforeUpdate and If statements, but I'd like the flexibility of being able to add cities and states regularly in the table rather than going to the code each time.
Thanks for any help!!!
Andy
I'm working on a form--a portion of which has two fields:
City:
State:
I'd like to write some VB code that would automatically fill the state field when the user enters a common city in the city field. I have a separate table with the same two fields and records like this:
1 Boston MA
2 Springfield MA
3 New York NY
etc. I'd like to use that table as the reference (the brains) driving the auto state completion task.
I've been using BeforeUpdate and If statements, but I'd like the flexibility of being able to add cities and states regularly in the table rather than going to the code each time.
Thanks for any help!!!
Andy