View Full Version : Searching A LIST BOX???


Misanthrope
03-19-2001, 09:08 AM
I have a form with a list box that has all of my needed data. I have a command button on the form with the intent of searching the list box. When I click the FIND/REPLACE box appears. I enter the data I wish to locate in the list box and hit find. I get a message saying that my list box is not searchable. How do I make this list box searchable? Here is the code behind the button
Private Sub Command6_Click()
On Error GoTo Err_Command6_Click


Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_Command6_Click:
Exit Sub

Err_Command6_Click:
MsgBox Err.Description
Resume Exit_Command6_Click

End Sub

[This message has been edited by Misanthrope (edited 03-19-2001).]

llkhoutx
03-19-2001, 10:51 AM
Search and compare the selected listbox value(s) utilizing DAO code.