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

Forms!Display!Combo170.Requery
Forms!Display!TTNUMBER.SetFocus
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.

Bill