Is this possible-auto type

[mrrayj60]

When I add a record in a form the user types in the address, can it auto filter to known addresses in the the table and allow the user to select that address, thus saving typos if I let them type the whole address. Duplicates entries are allowed in the table and it will be an access page so it must work when I save it as an access page. Thanks all.

 

[missinglinq]

Some questions before we start on this:

1. What version of Access are you using
   
2. What exactly do you mean by an Access "page?"
   
3. Where are these addresses coming from.
   
4. Are these addresses in a single field or (as it should be) in separate fields for street address, city, state and zip?

 

[mrrayj60]

Some questions before we start on this:

1. What version of Access are you using
   
2. What exactly do you mean by an Access "page?"
   
3. Where are these addresses coming from.
   
4. Are these addresses in a single field or (as it should be) in separate fields for street address, city, state and zip?

2003 access, I saved it as a Data Access Page so the guardhouse can add visitors. They are adding records via this form into the table. I read somewhere that as they type in say 12345 Brooksville St, by the time they type 123 the rest of the address can be found, or maybe it is stored in the form from previous typing. Like filling in form online, once you type stuff it comes up from memory. and yes address is a seperate field in the table. They sometime type 12345 Broksville instead of Brooksville sO i'm looking for a way to streamline the entering process. Thanks for your review.

 

[John Big Booty]

When I add a record in a form the user types in the address, can it auto filter to known addresses in the the table and allow the user to select that address, thus saving typos if I let them type the whole address. Duplicates entries are allowed in the table and it will be an access page so it must work when I save it as an access page. Thanks all.

Sound's like a job for a Combo Box.

If you are not already using a Combo Box then your data may not be correctly normalised.

 

[mrrayj60]

I have not been able to get controls like combo, or list boxes to work in a access page. Thanks

 

[John Big Booty]

I have not been able to get controls like combo, or list boxes to work in a access page. Thanks

That sounds like another symptom of non normalised DB design.

Are you approaching this project from an Excel background and design perspective?