[RESOLVED] Syntax problem

[mocode]

Hi

What is wrong with this code:

DatGruppe.Recordset.FindFirst "Type Like '" & grTyp & "'" And "Diameter Like '" & grDia & "'"

[pound]

DatGruppe.Recordset.FindFirst "Type Like '" & grTyp & "' And Diameter Like '" & grDia & "'"

Check the concat' operand again

[moinkhan]

Find doesn't support multiple fields....

[NateBrei]

Use '.Filter' instead for multiple criteria.

Nate

[mosteel]

filter didn´t work ....

Please help..... Mosteel

[NateBrei]

The problem could be a couple of things:

1) If the data type of a field is string, you need to use the single quotes around the value. If the data type is numeric, you do not use the single quotes.

2) It may also have to do with the Like pattern you are using. You are not using an * anywhere in your like strings. Consequently, it may be searching for an exact match. So, you may have to do something like these:

'For items that begin with your criteria string
DatGruppe.Recordset.Filter = "Type Like '" & grTyp & "*' And Diameter Like '" & grDia & "*'"
 
'For items where your string could be anywhere in the field data
DatGruppe.Recordset.Filter = "Type Like '*" & grTyp & "*' And Diameter Like '*" & grDia & "*'"
 
'To restore your recordset to all records
DatGruppe.Recordset.Filter = ""
'or
DatGruppe.Recordset.Filter = adFilterNone

Give those ideas a shot. Also, note that unlike the Find methods, Filter is a property so you have to use the equal sign in front of your criteria string.

Hope this helps.
Nate

[mosteel]

Thank you i´t works