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?
One last thing!
- Thread starter sarny
- Start date
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.
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 know a few things...
- Local time
- Today, 06:14
- Joined
- Oct 23, 2001
- Messages
- 2,633
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.
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.
