i have more that one button that i am trying to search different things. here is my first button which is my search button for the sku
- Private Sub cmdSearchSku_Click()
-
-
Dim bkmk As Variant
-
Dim strField As String
-
-
Me.RecordsetClone.MoveFirst
-
-
Me.RecordsetClone.FindFirst "[SKU] Like " & Chr(34) & Me.txtSearchSku & "*" & Chr(34)
-
-
-
-
If Me.RecordsetClone.NoMatch Then
-
msgBox "No Match"
-
Else
-
bkmk = Me.RecordsetClone.Bookmark
-
Me.Recordset.Bookmark = bkmk
-
End If
-
-
i want to add another search button for the description and another one for code. so three in total. when i add the same code to the search by description button, it just come back no records found, when i type in exactly what i am looking for, and the same for nmfc code. i tried to make the variable a bkmk1 and bkmk2, but then it gives me an error! please help!