Auto Enter County, State & Zip after entering City

Anonymous
2010-12-27T19:38:00+00:00

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!

Microsoft 365 and Office | Access | For home | Windows

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.

0 comments

51 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2010-12-27T19:42:08+00:00

    If you have that information entered in a table, then you don't need to have Access AutoEnter that information.  It CAN be DISPLAYED using a query or you can have a combo box to select the city and have some UNBOUND text boxes display the selected values.  But you don't store them in with the rest of the record.

    See my sample here for how to include extra fields to display in a form.

    http://downloads.btabdevelopment.com/Samples/combos/Sample-FillInFields.zip

    Bob Larson, Former Access MVP (2008-2010)

    Was this answer helpful?

    0 comments