Auto Complete Form or table fields

[faodavid]

Hi

Im trying to find a way to automate or make data entry quick either on a form or the table.

The database Im building is a music venue database

Form Boxes include

Venue Name
Street Address
Town


County
Region
Postcode

Say for example If I know Venue Name and postcode is there a way of autofilling Street, Town, County and Region or just some of them rather than having to type this info manually? Occasionally there are venues which have the same name, I wondered if I qualify my data entry further ie enter venue and town is there a way to autocomplete the rest?

This is my first ever database if you could bear this in mind - whats the quickest way to enter data by using a form or directly into the table?

Many Thanks in advance

[June7]

What is this form for? What table are you entering data into?

You could have a table of Cities/Towns with their County, Region, Postcode. However, many cities have more than one postcode.

[faodavid]

Hi
Currently entering data in a venue table which contain the above - postcode is the venue postcode
Dave

[June7]

So purpose of form is to create unique records in Venues table?

Why would more than one venue have same name? I presume they have different addresses.

Options:

1. A city/town can have only one county and region. So this can be a table. Then if your city/towns have more than one postcode, have another table for city/postcodes. On the form, in combobox select city and the county/region tag along. Then in another combobox, only postcodes available for that city/town will be available. All this will require some VBA code.

2. The Cities and Postcodes tables could be combined but that would mean multiple records for each city/town where they have multiple postcodes. Then user would have to choose based on postcode. In this case, only enter the postcode and the city/town, county, region will all tag along.