Automatically enter Data

[Mike]

Im starting in on a new database and i need to have the "Street" feild
automatically enter in a the name of the street from a list of streets in a
seperate table.
Once the user starts inputting the first letter of the street name i want to
have all suggestions for all streets that begin with that letter show in a
pull down window or something similar. If 2 or more letters are typed the
list will shorten etc.
Can access do something like this?

 

[John Vinson]

Im starting in on a new database and i need to have the "Street" feild
automatically enter in a the name of the street from a list of streets in a
seperate table.
Once the user starts inputting the first letter of the street name i want to
have all suggestions for all streets that begin with that letter show in a
pull down window or something similar. If 2 or more letters are typed the
list will shorten etc.
Can access do something like this?

Very easily.

Use a Form to enter data into your table (never use table datasheets
for anything other than development and debugging). Put a Combo Box (a
"dropdown") onto the form, using your Street table as its row source,
bound to the street field.

The Toolbox Wizard will step you through putting this combo onto your
form.

John W. Vinson[MVP]

 

[Mike]

John,
Thank you so much i had tried something similar with the list box and it
didn't work as i had hoped. I didn't think the combo box would do the trick.
Much simpler than i thought.
How about something a little tougher.
If the user enters a street name that isn't in the streets table into the
street field is there a way to easily add it to the streets table? It would
be nice if the user were given the option to add it or not.