Search Main Form Based on Contents in Subform

[MintChipMadness]

I attached my database with no confidential information. I am trying to get the search field [contents] in my DataEntry form to work. I want it to search all the contents and show the only the records that have those contents in the main form. The main form shows all the boxes. I originally just added the [BoxContents].[Contents] field to the main form and sorted the query based on what was entered in the text box. The problem is there can be multiple content records for each box so it shows the same box over and over again depending on the amount of contents. Any help on this would be greatly appreciated. I read in another thread that this might not be possible but it is worth asking the question because it might work in my case.

[MintChipMadness]

I received a reply in one of my other threads. It was for a different problem but exposed this problem. June7 said that you cannot search that way. I guess my solution would be to delete the search field.

The thread where this question was answered
https://www.accessforums.net/forms/c...ord-27175.html