form for searching records

  • Thread starter Thread starter ian
  • Start date Start date
I

ian

Hi guys, sorry for the N00b question, but i have a form, and when i go to
one of the fields to type in what i want to search for, it just edits the
value that is already there. it doesnt search all records for that number.
How can i fix this?

Many thanks,

Ian
 
Ian, provide another text box for the search value. Trying to use the same
text box for data entry and for searching can be confusing for the user.

If the value is unique, use the AfterUpdate event procedure of the control
to FindFirst the match in the RecordsetClone of the form, and then set the
form's Bookmark. Example code:
http://allenbrowne.com/ser-03.html

If there could be multiple matches, you may want to set the Filter property
of the form, so the user can quickly find the desired one.
 
Back
Top