form for searching records

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
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Copy previous record into form field 0
WORD VBA Search and switch to advanced ... 1
Adding data to MS Access from csv file 0
Request Form - Alert Team Member 0
Is this possible? 0
MS ACCESS: SEARCH in a split form 0
Can I save a sql statement generated by a search form? 1

Top