One last thing!

[sarny]

My database is ready to launch but when using it i noticed that for the combo box, the user will not be able to use the arrow keys to move down the list. Also normally you can type press the letter 'G' for exapmle to take u to the 4th item in the list spelt with G, but on mine if you press 4 'G's it it types them all out therefore finding no item at all. Does this make sense?

 

[sarny]

All the problems are cropping up now. If i click the button to move 2the next record, the focus is not on the first tab field, thus the user would have to click on the 1st field to begin data entry. Any ideas?

 

[jwindon]

To set your tab to the first field in a new record, you need to put this code on the OnCurrent event of the form.

Me.FirstFieldName.SetFocus


As for the combo thing....IF there is NO item in the list that is spelled GGGG, no item WILL be found. Look at the properties for the control box. Make sure you set LimitToList: Yes and on the datasource, click the build button and sort the field ascending in the query grid.

 

[David R]

I think he's referring to the trick that places like Mapquest use when you want to scroll through their dropdown for State abbreviation. If you type "m" 4 times, you end up on Mississippi.

I know that this is NOT how Access comboboxes work, like jwindon said. I don't know how they do work in other cases, though.
You might look into making the combo box drop down automatically? (Me.YourCombobox.Dropdown) Then you might be able to type G, {Down}, Enter. I haven't tested it.