Modify a form in Access 2007 using VBA and test your code:
1. Currently users use a combo box to pick a 'site' such as "18113-45" from a list. For more rapid data entry, the users want to be able to tab to enter a 'site number' in the site selection field and type '45' to bring up site 18113-45 for data entry instead of typing the entire text string 18113-45. Allows user to tab to next field to a) enter the site number into the form field and b) move to the next field.
All 'site numbers' have unique two digit numbers in the xx location as follows: 18113-xx or 18114-xx.
Need the project done by next Monday May 12. email me for the database and I will post the link for you to download it.
Estimate Approx 1hr-2hr work for experienced VB programmer to download DB, create code, email questions and test.