Access DB: FindRecord Method - TechRepublic
General discussion
May 30, 2001 at 05:14 AM
jbon_2000

Access DB: FindRecord Method

by jbon_2000 . Updated 24 years, 11 months ago

I have used DoCmd.FindRecord to search for an ID #. When used, it searches all Fields. If I limit it to the Current Field, it finds nothing. Does anyone have tips. See Code Below:

Private Sub cmdSearch_Click()
On Error GoTo Err_cmdSearch_Click
DoCmd.OpenForm “Book Form”
txtNum.SetFocus

If Not txtNum.Value = “” Then
DoCmd.FindRecord txtNum.Value, acDown, , acSearchAll, True, acAll
txtNum.Value = “”
DoCmd.Close acForm, “ID # Search”

This discussion is locked

All Comments