This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm trying to make data entry easier. We have a relatively small client base (3 counties) and I'm wondering if I create a table with all of the cities in the counties grouped together with states and zips if Access will be able to AutoEnter the County, State and Zip after the City is entered?
(I've only got beginner Access 2010 under my belt....hoping they will send me to level 2 at the very least...)
THANKS so very much for your time!
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I'm searching for an example of the mutiple tables I've created to make sure I have things done correctly before I try to go any further and all I'm finding is samples/examples of addresses the way I had them before..........please tell me I didn't separate information unnecessarily
sadly, i did, and i kept getting errors on the subforms...something about data type not matching.
it's about time to get someone standing over my shoulder :(
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
I think you are getting intimidated unnecessarily. Try following the instructions without full understanding. Once you see how they work, you will probably understand. And, if there is anything you need clarification on, please ask.
Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2010 Blog: http://scottgem.wordpress.com Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries
I need to find myself a write-up on access forms for dummys now. I will return here as soon as I get to that point in the form creation that I want the info auto filled.
Read my two earlier posts about form/subform for data entry with two tables.
Build a little, test a little.
Scottgem,
I greatly appreciate your willingness to teach my stubborn head something. You are a gem:) I read thru that article in your blog....and most of it went so far over my head I'm not sure I caught anything :(
I need to find myself a write-up on access forms for dummys now. I will return here as soon as I get to that point in the form creation that I want the info auto filled.
See you shortly, hopefully!