Find function on Access 2000 (1 Viewer)

[flsvt]

I used to be able to use the find function in Access '97 and not specify a field to match or partially match. Since upgrading, if the record is not within ten records of the record that is on the screen I'll get "not found" and then I have to specify the field for Access to find a match. I'd like to be able to just do a global search throughout the database instead of the specific field. Can I?

Thanks.

 

[rajput]

Go to Tools and Options and Edit/Find tab and change the defult find behavior to General search. That should take care of that.

 

[musicmaker]

I have found in Access 2000, when you are in forms and you put a button on your form with the [FIND RECORD] function, it will NOT work on a field that has VB code attached to the [On Exit]. If you reroute the code away from [On Exit] the [Find Record] button will work O. K.

Hope this helps, musicmaker