Hi,
my search form uses the search query to show result in a new table window with the result!
and the quey is like this:
[Forms]![FormName]![txtSearchField] & "*"
How can I make the result List Box appear on the same search form not in a new window, please ?
Thanks
iboumiza
my search form uses the search query to show result in a new table window with the result!
Code:
'Search Query
Private Sub btnSearch_Click()
On Error GoTo Err_btnSearch_Click
Dim stDocName As String
stDocName = "SearchQuery"
DoCmd.OpenQuery stDocName, acNormal, acEdit
Exit_btnSearch_Click:
Exit Sub
Err_btnSearch_Click:
MsgBox Err.Description
Resume Exit_btnSearch_Click
End Sub
and the quey is like this:
[Forms]![FormName]![txtSearchField] & "*"
How can I make the result List Box appear on the same search form not in a new window, please ?
Thanks
iboumiza