Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Resetting a DataCombo list to the top of list?

Status
Not open for further replies.

Sideman

Technical User
Apr 21, 2003
41
US
Hi, people. Love this site!! So much help available that I get lost for hours reading!
OK, my question (p.s. I'm a beginner)...
I have a DataCombo box and several TextBoxes bound to a ADODC data control. I make a selection from the dropdown DataCombo and populate the TextBoxes with related data. I also have the usual Next and Prevoius Command buttons, and a "Reset" Command button. The Reset Command is supposed to reset the Text boxes to the first record (this is working)and the Combo box to it's initial "empty" state in order to allow the user to again find a record starting from the beginning of the list(this isn't working). Well, after I've made a selection from the Combo box everything resets properly ...(and here's my glitch)...except that the Combo box retains the last selection. I can't seem to figure out how to reset it to it's beginning state (blank), or even the first record in the recordset.
If you could point me in the right direction I'd be most grateful.
Thanks to you all.

Of all the things I've lost, I miss my mind the most!
 
Set DataCombo1.RowSource = nothing
DataCombo.Text = vbNullString
 
Thank you CCLINT.
I'll give that a try.
You all are VERY helpful.

Of all the things I've lost, I miss my mind the most!
 
I apologize for neglecting to respond back. Your suggestion worked beautifully.

Thanks again, CCLINT...one of these days I hope to be able to help others in these forums like you do.

Of all the things I've lost, I miss my mind the most!
Sideman
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top