Solved

Access autocomplete, autofill data entry based on another table

Posted on 2013-05-25
2
821 Views
Last Modified: 2013-05-26
Hi

I am using access 2010.  I have table called tblPeople with one field [Fullname] .

Example names in this table....  Galen Simpson,   Garnet Doe,  Gail Gaudet

I also have form that is bound to another table  ---   tblSales.

tblSales has been set up to only accept names that are found in tblPeople. In this example,  by the time 3 letters have been entered, Access should be suggesting the rest.

How is this done?
0
Comment
Question by:peispud
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 39196413
You need to use forms for data entry.
On your form you can use a combobox to provide the list of names to select from.

You can build the combobox using the wizard that runs when you add a combo to your form.

Names can and do change, so the normal practice is to store the record ID value from tblPeople in each record in rblSales.
The combo wizard assumes that this is what you want to do.  You can still select from the list using the name and display the name- again the wizard deals with this.
0
 

Author Closing Comment

by:peispud
ID: 39198143
Thank you for your reply.  I took your advise and assigned a record ID for the person as the reference.  I can see how this approach is very solid.

Have a great day.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
On Key Down Access 2010 6 41
update query 4 25
MS Access 2012, Split Form 2 39
Local HTML file to display local Access MDB data in browser 4 18
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question