Misanthrope
New member
- Local time
- Today, 16:42
- Joined
- Mar 16, 2001
- Messages
- 5
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).]
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).]
