Find Window

[William5271]

I am setting up an Access database and in order to find records in the
database we need to use the find window. When we have just opened the
database and push Crtl-F the window comes up, but the look in feild is set to
"ID." Is there any way to make this look in the main feilds rather than the
id feilds automatically, without having to change it manually?

 

[Jerry Whittle]

If this is a database used only on one computer, go to Tools, Options,
Edit/Find tab and select General Search.

If used on different computers, put the following code in the Open event of
the startup form or a commonly used form. It might take a couple of times
before the settings hold.

'Set some database defaults found in Tools, Options
' Put in the Open event of the startup form
' Set Default Find/Replace Behavior to Start of Field Search
Application.SetOption "Default Find/Replace Behavior", 1

 

[William5271]

Thanks so much, that worked!

If this is a database used only on one computer, go to Tools, Options,
Edit/Find tab and select General Search.

If used on different computers, put the following code in the Open event of
the startup form or a commonly used form. It might take a couple of times
before the settings hold.

'Set some database defaults found in Tools, Options
' Put in the Open event of the startup form
' Set Default Find/Replace Behavior to Start of Field Search
Application.SetOption "Default Find/Replace Behavior", 1