This database has a lot of redundancy and I can't change it so I have to go with the flow....
I have been asked if I can have a form autocomplete an address that was previously typed (like Excel does). With that, I understand that with a combo box seems to be the way. However, if the address is NOT in the combo box, it will not autocomplete. I know I can set a combo box to accept an entry not listed.
Is there a way around this?
The database contains information from a paper form that a customer brings to us. On that form it contains data that we must verify for them. It is generally property. Only one piece of property can go on a form. So, if the person has multiple things, then they have multiple forms. Therefore, we have to enter each form separately in Access (this again is something I can't change). This means their name, address, phone number, etc.
For the ones entering the data, how can I make this easier for them? They are asking for only the address to autocomplete, but I know they would appreciate the customer's name and phone number to autocomplete as well.
*please note, I am not asking for it to automatically populate once the name is entered because a person could have a different addresses and phone numbers as some of them are business owners coming to verify property. Also, it can't necessarily autocomplete from the row above due to repeat customers coming back and there being different ones entered from the last time they were here.
I forgot to mention, that I have a table for the property and a form for data entry only. I do not have a separate table for the customers data. I tried that and made a relationship in hopes that it would autocomplete, but no such luck so I deleted them.
I have been asked if I can have a form autocomplete an address that was previously typed (like Excel does). With that, I understand that with a combo box seems to be the way. However, if the address is NOT in the combo box, it will not autocomplete. I know I can set a combo box to accept an entry not listed.
Is there a way around this?
The database contains information from a paper form that a customer brings to us. On that form it contains data that we must verify for them. It is generally property. Only one piece of property can go on a form. So, if the person has multiple things, then they have multiple forms. Therefore, we have to enter each form separately in Access (this again is something I can't change). This means their name, address, phone number, etc.
For the ones entering the data, how can I make this easier for them? They are asking for only the address to autocomplete, but I know they would appreciate the customer's name and phone number to autocomplete as well.
*please note, I am not asking for it to automatically populate once the name is entered because a person could have a different addresses and phone numbers as some of them are business owners coming to verify property. Also, it can't necessarily autocomplete from the row above due to repeat customers coming back and there being different ones entered from the last time they were here.
I forgot to mention, that I have a table for the property and a form for data entry only. I do not have a separate table for the customers data. I tried that and made a relationship in hopes that it would autocomplete, but no such luck so I deleted them.
Last edited:
