ComboBox with ADO

[sonman]

I have some command buttons on my form to move from record to record. (i.e. Next Record, First Record, Previous Record and Last Record.) They worked fine moving from record to record untill I put on a ComboBox control. Now the only way to move from record to record is to select the record from the combobox. After awhile, this database is going to get to big to do this with, but I still need to keep the combobox there.
How can I allow the user to use eather the buttons or the combobox to move from record to record.

[Johnny101]

I dont really see a problem here. If the user chooses an item from the list, the code you have now will handle it. If they click a directional button, the code you have now will handle it. If you wanted to, you could for the user to choose a section of records from the list (100,200,300,400) and so on, and then force them to navigate through the individual records one at a time with the buttons.

Just a thought,
John

John Pirkey
MCSD
www.ShallowWaterSystems.com

[sonman]

Pretty good thought, but I did try that. If I remove the ComboBox control, then the directional
buttons work. If I place the ComboBox back on then
the buttons don't work. However, if you click on one of the button's you can see the text boxes flash as if they were trying to move to that record but they dont. I wonder if there is something about the ComboBox that I am not aware of that might be locking on that record.
I do know that there is a Lock property but I am not setting it.