How do I create a search button on only one field.

[rebfein]

Hi there,



First, big thanks to all you Access Masters who've assisted me in my endeavors. You have my gratitude.

So, here's another issue for the form I've created. I want to add a simple Search button. The purpose of this form is to assist the engineers in finding similar supplier parts for the ones (by 'our' part number) in our products. There are over 900 parts in this database. I've put each supplier and their part number in a separate table [a many (suppliers) to 1 (our part#) relationship], and be trackable by our part number.

This database is used in our supply chain management efforts.

I've set up the design so that it shows our part number, a part description and a classification at the top of the form.

Below that I want to have the user the part number they need, hit the search button, and have the list of suppliers and their part numbers that apply to our part number; appear at the bottom of the screen.

Here's the design:


Here's what I'd like it to look like after:


However the search field is not working as the code and stuff that I've researched is not working well. As I've said before and I'll repeat it again, I. DO. NOT. CODE. WELL. Nor do I understand where code snippets go when I do get them.

Here's the code:


Here's the macro builder screen, and I have NO idea where I'm to put this stuff:


HELP!!

[azhar2006]

Hello rebin
See this example of Alan Brown.
http://allenbrowne.com/ser-62.html

[Micron]

Here's the macro builder screen, and I have NO idea where I'm to put this stuff:

If you download the sample db in that link and look at the code behind the forms (in the VBE - Visual Basic Editor) you will see how and where vb code is dealt with. That is also the answer in the 4th sentence of line two in your picture of text.
It cannot go into a macro. Macros are a separate thing where you click & select options and maybe type in some parameters in an attempt to do what code can do. However, macros are limited in comparison to code.

Let us know if the link is of no help and why.

Not sure I get why you say it's not working. It looks like you have a set of suppliers

[orange]

Show us your tables and relationships.

It appears you are using some standard classification system for Parts.
It also seems you are working along these lines (found via Google).

If you could post a copy (limited data) of your database and specific instructions, I'm sure some readers can offer more focused advice. The Allen Browne search is often referenced-- it's good and has description.

Good luck.

[rebfein]

Dear azhar2006, Micron and Orange,

Thank you so much for your responses. After much experimentation with your solutions and my boss' direction, we decided on a simple find button as the quickest solution at this time.

As always, I do appreciate the feedback and the time you've given me for this.

If anyone knows of an in person Access users group in the LA, Orange or Riverside counties; please let me know.

Sincerely,

Rebecca Feinstein

[orange]

Rebecca,
Thanks for the feedback/status update.

Just looking through some of your posts and notice that your are solving "pieces" of something (at least in my view).
Do you have a big picture description showing where these "pieces" fit?
People here are willing to help, but need to see the "plan or artist's concept" of the overall requirement.
Having the 30,000 foot overview and a picture of the things involved will help you and readers and will improve communications.

[rebfein]

I would love to be able to show you some of the project that I'm working on. However, I'm not able to do so, boss' orders.