[VBA+Access 2003] Making search result appear in List Box

iboumiza

New member
Local time
Today, 01:06
Joined
Aug 5, 2011
Messages
3
Hi,

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
 

Users who are viewing this thread

Back
Top Bottom