Recent content by Ian Stuart

Perfect, thanks Fizzio

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] &...

Surely that will only find text in a particular field? Presumably I would need to create a loop to go through all the fields on the form except the one(s) I didn't want to search. I am thinking that it may be easier to use the built in find dialog box...I just don'tlike the default options...

got it...it was finding the text in the search string text box!!! Any way of omitting that field (only) from the search criteria?

That gets rid of the error message thanks (I just found errmsg.xls which was very helpful as well) Unfortunately the search still doesn't work! It only seems to search for the text on the current record not all records

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...