I'm trying to use the Search all fields (acAll) option of FindRecord to search fields on a form. I'm using the following code-

Private Sub Combo170_AfterUpdate()

Dim Srch As Variant
Set Srch = Me!Combo170

DoCmd.FindRecord "Srch,,,,,acAll,,"

End Sub

If I substitute the "Srch,,,,,acAll,," line with "Srch" it works just fine, but obviously only searches one field. I would really like to search all of the fields.