Search results

Thanks for your reply AccessBlaster. The thing is, I want the results to be shown on the bottom of my split form. Not in a drop down box. The database Mihail assisted me on is almost there. A few issues occur, but it is really close to what I am looking for.

Mihail, Once again thank you for your help. It's almost there. The other column is Comments Not Notes. For some reason if I search, let's say Jackson - only one result shows up, but in the unfiltered query there should be several that match Jackson (Opened by, Assigned To, some job descriptions...

Click on the Search Tool button in case list and it will take you to my search (split) form. I want the button to search the Search Query for whatever is in the text box and display it down below. I also can't get the refresh to work correctly. Thanks for you help.

Thanks for trying to help, but I am stuck. My knowledge is not there when it comes to Access and macros/vba/modules. I can share my database to give a better idea of what i'm trying to accomplish.

To be more specific, is there an ApplyFilter macro I can use? Right now I am only able to search one field on a form using this command [Notes] Like "*" & [Forms]![Search Query]![Text17] & "*" The other fields are [Description], [Opened By], and [Assigned To]. I have not found out a way to...

Any help would be appreciated.

Thanks for your reply. No I want to search all fields withing the one form.

So, I've been trying to accomplish this, but to no avail. I am trying to create a Button that would search a specific table for any text string I enter in an unbounded-text field. Can this be accomplished Via a macro? Also, I do not want same entry appearing multiple times. Can anyone assist...