View Full Version : Search a specific field in a form


The Red Star
11-13-2001, 12:34 AM
Is there a way to make a button that searches in a specific field each time the button is clicked. This can be in the normal access search, as long as it automatically searches in that field.

example: I have a form with a number of fields in, and i might be adding data in any of these fields, with the cursor anywhere. Then i want to search for a name, and so i want to search in the name field, without clicking in the field and then having to click search. All i want to do is click the button.
Is there a way? Many thanks for taking the time to read this - any replies or ideas will be gratefully recieved.

LQ
11-13-2001, 03:57 AM
There are several ways you could go about this. Here are some ideas...try them out and post back with problems.
http://www.access-programmers.co.uk/ubb/Forum4/HTML/001967.html
http://www.access-programmers.co.uk/ubb/Forum4/HTML/002187.html
http://www.access-programmers.co.uk/ubb/Forum4/HTML/002294.html

Another idea is to use the wizard to create a combobox that will look up a specific record. Look in the help files index under Combo Boxes, displaying specific record.