Simple search function in access?

Hi, I have a form that has boxid and boxbarcode text boxes. When i use the controls at the bottom it scrolls through the records correctly. What I'm looking for is to lock the boxbarcode box and have the boxid box open so you can search for any string of letters and hit a button and it will fill in the corresponding barcode to that box in the boxbarcode box if the search string is correct. Sorry for the repeated use of the word box, I hope that made some sense!
MrdogkickAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

peter57rCommented:
You cannot use the same control for data entry and for searching for records in the form.
If you want to search then you must have separate controls - in the form header say.

You can use an unbound form and do the search, or you can lookup corresponding values during data entry (of new records or to modify records)  
MrdogkickAuthor Commented:
Sorry, I really didn't understand any of that! Please could you elaborate?
peter57rCommented:
If your form is a data entry form, where you normally save records into a table or you are viewing records in the form, you cannot use the same boxes (controls) to search for records.

You have to use different controls (boxes) to enter your search values and then run some code to find the
record(s) that match your search values.
MrdogkickAuthor Commented:
ok, so could you let me know how to do that or if you know of an easy-to-follow example...
peter57rCommented:
If you are trying to find the record that matches the id you enter, then add a combo box to the form header.
If you use the wizard to do that, and choose the option to 'find a record in my form' it will all be done for you.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.