Search results

I want to use a text box ("txtSearch") on a form to dynamically reduce the contents of a list box ("lstIssue") The lstIssue data source is: SELECT [tblIssue].[IssueNo], [tblIssue].[Description] FROM tblIssue WHERE ((([tblIssue].[Description]) Like "*" & [Forms]![frmSearchIssue]![txtSearch] &...

I am using the following code to find a record on a form: Me.txtFindString.SetFocus If IsNull(Me.txtFindString) Then MsgBox "Please enter a search string", vbOKOnly Else DoCmd.FindRecord Me.txtFindString, acAnywhere, , acSearchAll, , acAll, True End If and...