Search Button to search entire records VBA

[excellenthelp]

Hello Accessers!

I would like to know why the code below is not functioning properly. When I type in an acronym in the textbox, it keeps saying there is an error "Run-time error '3345': Unkown or invalid field reference 'ABO'." I do have ABO in the field.

The dysfunctional code:

Private Sub btnFind_Click()

    If (TxtFind & vbNullString) = vbNullString Then Exit Sub
    Dim rs As DAO.Recordset
    Set rs = Me.RecordsetClone
    rs.FindFirst "[Acronym] = " & TxtFind
    If rs.NoMatch Then
        MsgBox "Sorry, no such record '" & TxtFind & "' was found.", _
               vbOKOnly + vbInformation
    Else
        Me.Recordset.Bookmark = rs.Bookmark
    End If
    rs.Close
    TxtFind = Null
End Sub

The red highlighted line is where the debugger leads me to. Something with identifying the field? I would like to enable the search procedure to search throughout the entire records rather than just a specific field. How may I write such a line or two?

Thanks!

[excellenthelp]

Accessers,

Ah, the line works now. The highlighted line was updated from:

rs.FindFirst "[Acronym] = " & TxtFind

to

rs.FindFirst "[Acronym] = """ & TxtFind & """

However, I want to have the search perform the search in all of the fields rather than just a specific field. What is the parameter for this to replace [Acronym]?

Awaiting for an excellent help.

Thanks!

[June7]

Text fields require criteria to be delimited with apostrophes. Date/time fields use #. Numbers don't need anything.

rs.FindFirst "[Acronym] = '" & TxtFind & "'"

EDIT: If you want to search all fields then have to build filter criteria for all fields. How many fields?

[excellenthelp]

June7,

Thanks for a quick response and short and clear explanation. There are 7 fields on the form that I would like to search from. They vary from Text, Number and Hyperlink.

Hope this helps.

[June7]

I have a form with combobox for user to select field to search and then another combobox to enter search parameter. Code changes the second combobox RowSource based on first combobox selection. If it's a text field, they can select from list or enter any text. Then the code builds appropriate filter string for the selected field. If it's a text field then the string will be a LIKE and wildcard filter.

Alternative is 7 unbound controls to input parameters then the search can include any or all. Review: http://allenbrowne.com/ser-62code.html

[excellenthelp]

Thanks for the tip. I will play around with different ways that you suggested.

Marking this as SOLVED.