Thanks for your reply.
I am not sure I understand how to set this up.
Could you give me an example?
The following cities are located in Clay County:
Ashland, Barfield, Lineville.
The following cities are located in Calhoun County
Anniston, Oxford,
Thanks
"salad" <oi*@vinegar.com> wrote in message
news:ZH******************@newsread3.news.atl.earth link.net...
Leon wrote: How do I get a table to autpmatically enter the County name in the next
field when I enter the City name?
In the AfterUpdate event of your for County.
Me.County = Dlookup("County","LookupTable","City = '" & Me.City & "'"
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----