AutoComplete - Advice before I start

[Peter Noneley]

Hi,

I have been asked to make a simple database. At the moment I have not
created anything. I would like advice before starting.

I plan to have a table of personal details called PEOPLE.

One of the fields is the City they live in.

I will have another table called CITY to hold all the possible City
names.

When I am using the PEOPLE table and entering the City I would like to
be able to press a letter, such as B and have a list of all cities
beginning with B appear. As I type more letters the list will focus
in, so BR would shown Bradford and Bristol. I could then click on the
city I want.

My questions:

(1) Is this possible?
(2) Where do I start?

Thanks.

Peter
Cardiff
Wales
UK

[storrboy]

On Mar 6, 6:26 pm, "Peter Noneley" <[e-mail]:

Hi,

I have been asked to make a simple database. At the moment I have not
created anything. I would like advice before starting.

I plan to have a table of personal details called PEOPLE.

One of the fields is the City they live in.

I will have another table called CITY to hold all the possible City
names.

When I am using the PEOPLE table and entering the City I would like to
be able to press a letter, such as B and have a list of all cities
beginning with B appear. As I type more letters the list will focus
in, so BR would shown Bradford and Bristol. I could then click on the
city I want.

My questions:

(1) Is this possible?
(2) Where do I start?

Thanks.

Peter
Cardiff
Wales
UK

Don't edit data directly in tables. Use a form.
A combobox has an Auto Expand property. It is effectivley Auto
Complete. Set this to Yes and it will do as you've requested.

[Peter Noneley]

On 6 Mar, 22:45, "storrboy" <[e-mail]:

On Mar 6, 6:26 pm, "Peter Noneley" <[e-mail]:

Hi,

I have been asked to make a simple database. At the moment I have not
created anything. I would like advice before starting.

I plan to have a table of personal details called PEOPLE.

One of the fields is the City they live in.

I will have another table called CITY to hold all the possible City
names.

When I am using the PEOPLE table and entering the City I would like to
be able to press a letter, such as B and have a list of all cities
beginning with B appear. As I type more letters the list will focus
in, so BR would shown Bradford and Bristol. I could then click on the
city I want.

My questions:

(1) Is this possible?
(2) Where do I start?

Thanks.

Peter
Cardiff
Wales
UK

Don't edit data directly in tables. Use a form.
A combobox has an Auto Expand property. It is effectivley Auto
Complete. Set this to Yes and it will do as you've requested.- Hide quoted text -

- Show quoted text -

Thanks for the reply and info, much appreciated.

Peter.