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.
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!
Scottgem [MVP] wrote in
news:*** Email address is removed for privacy ***
m:
I'd rather have a newbie understand about normalization and then decide when it is overdone then confuse them with the
concept of overnormalization.
I think this is an extremely ill-chosen example for normalization as
in most apps, it won't be an appropriate structure.
David W. Fenton http://www.dfenton.com/ contact via website only http://www.dfenton.com/DFA/