Creating a Search Form

[midnight_puppy_2303]

Hello everyone,


I want to create a Search Form. There will be a textbox such that when I type a keyword in it and hit a “Search” button, it will give me a list of Report No.’s of records that have any field that contains the keyword entered in the textbox. Then when I click on any one item on the list, it will reveal the form in details, whose design is exactly the same as the “TeledyneForm” that I created.
I am an Access newbie, so it would be great if anyone could give me step-by-step instructions. I attached the Access file so that you guys can have a look.

[midnight_puppy_2303]

Someone pointed out that I should not have cross-posted. My apology, everyone.
Here's the link to the original post:
http://www.utteraccess.com/forum/Cre...-t2020574.html
Also, I want to delete this post but don't know how.

[ranman256]

Try this for an example...(it only does so much)

TDY2.zip

[orange]

Forum participants are only upset with cross posting when you don't tell us that you have done so.
Simply show the link of the cross post; tell us what you've done, and it would be nice if you marked it solved when that happens on whatever forum.

As for the search, take a look at this sample
https://www.accessforums.net/code-re...rch-43055.html

Good luck.

[June7]

And another http://www.allenbrowne.com/ser-62.html

Or a dynamic parameterized query might be preferable http://www.datapigtechnologies.com/f...mtoreport.html

Apply the same wildcard criteria under each field you want.

[midnight_puppy_2303]

Thank you very much for everyone's help. I was able to find out the solution based on June7's suggestions.