Tetx box lookup

[coryt]

Text box lookup

I am trying to make a form with only 1 text box. When the user scans a value into the textbox, the value is compaired to values that I have imported into a table. If "it" finds a like value in the table, it displays a message box stating it found a match. If it doesn't find a match, it displays a different message box satting it didn't find a match. I'm sure this is a pretty simple problem, but I am having a major cramp in my head... Thanks in advance.

P.S. The value that the user scanns doesn't need to be stored anywhere. The form is simply used as a comparison devise to find certain codes.

 

[dcx693]

Try the DoCmd.FindRecord command.

 

[coryt]

How?

 

[Mile-O]

If DCount("[FieldInTable]","tblYourTable","[FieldInTable] = """ & Me.txtYourTextbox & """") > 0 Then
    MsgBox "Match found."
Else
    MsgBox "No Matches Found."
End If

 

[coryt]

Works Perfect. Thank you very much Mile!!!