If I have a search form which contain some search key and they are in text fields. I just want to search my the value i wanted

eg if I just key in A123 in the cert no field in the search form it can show records like
Name Cert No
  A A123
or if i key in A123, B234, C345 these 3 records in in the cert no field in the search form it show all records which contain any of these 3 values
it shows like
Name Cert No
  A A123
  B B234
  C C345

Thanks

I am not sure how you are implenting this. You just pass the field as parameters to the query behind your results form or report. Like this:

'-----
Dim stSearchValue As String
Dim stLink As String
Dim stDocName As String

stSearchValue = Me.TextFieldValue
stLink = "[SearchField] = Like " & "'" & stSearchValue & "'" & "*"

stDocName = YourFormOrReportName
DoCmd.Open(Form or Report) stDocName, , stLink
'-----

You may have to play with the syntax a little for the wildcard. This assumes the search value is at the beginning of the string. It can be in the middle or at the end. I have done this but don't have time to find it right now. Let me know if you still need help on this, or another poster can jump in.

HTH


mmcdonal