[lamsen]

hello everyone
i need to find a specific "brandname" of a "vehicletype" if it is exist before I add a new brand,
its my first time to use ".find" function with "where" i dont know if this is right

with rsbrands
    .Find "BrandName='" & Text5.Text & "'" where VehicleType='" & Combo4.Text & "'", 0, adSearchForward, adBookmarkFirst
        If (.EOF = False) Then
            MsgBox "That Brand already exist!", vbInformation, " "
        else
        'add code
        end if
end with

check my code please.
thank you

[lamsen]

already solve my problem, i used "open" before "find"
for those who have the same problem here's what i do

Dim rs As New ADODB.Recordset
rs.Open "select BrandName from Brands where VehicleID='" & text7.Text & "'", cn, adOpenStatic, adLockReadOnly
        While rs.EOF = False
        rs.Find "BrandName ='" & Text5.Text & "'", 0, adSearchForward, adBookmarkFirst
        If rs.EOF = False Then
            MsgBox "That Brand already exist!", vbInformation, " "
            Text5.Text = ""
            Text5.SetFocus
        else
            'my add code
        end if
        wend

hope this will be useful

[maj3091]

Well done on solving the problem and thanks for posting the solution for the benefit of others.

[BobRodes]

One little point: your if statement will always be true, because you'll only encounter it while eof is false. So you don't need it. Right?