
February 18th, 2005, 03:44 AM
|
|
Registered User
|
|
Join Date: Feb 2005
Posts: 1
Time spent in forums: 9 m 38 sec
Reputation Power: 0
|
|
|
Need help remembering combobox between records
I am working an a database for work. Daily we have to enter number of stops a particular driver does each day. The form where we enter this data is in tabular view and the Driver ID is selected from a combo box. The first three driver numbers are 31002, 31003, 31009 etc with large gaps inbetween driver numbers. Is there a way that when a record is entered (or a new one created) it selects the next driver from the list. i.e. if I enter driver 31003's stats then press tab to go to the new record the driver ID combo box will automatically be set to 31009.
I thought it would be as simple as incrementing the ListIndex property but this cant be altered.
Your help would be greatly appreciated.
P.S. Im using access 97
|