No retyping required

[Pudge27]

I have a very simple database that basically has 2 tables and 2 forms. It basically is tracking how and where sales people spent their allowances. This use to be kept in an Excel spread sheet and was an absolute mess with typos on peoples name and missing spending acct #'s. Is there a way that as a person begins to type a persons name in the text box of the form that access can bring up a previous value that was already typed.
Any help is appreciated.

 

[Cbrine]

Sounds like you need to use a combobox and not a textbox. You can associate the combobox values to a table. You will need to setup a query that runs off your table with all the names in it, each time the form is opened, to populate this combo box table with only unqiue instances of the names.

PS-Run a query on your data table, put the name field in it, add the name field a second time and change the totals option to count, and click the display checkbox to false(Do not display). Set this as a make table query to update the unique name list. Associate this table as the datasource for your combo.
Set your form open event to run the make table query, and you should have what you want. You will need to make sure your limit to list property for the combobox is set to no, otherwise they won't be able to enter new information. You should also set the make table query to run after each entry in the main table to update the values after a new entry.

Hope this helps.