Building a Filter Form

[dannileeb]

I am very new at all of this. I am trying to build a filter form to just pick out one item. I am trying to filter out Box Numbers that have been entered into the database to run reports on them. I think that I am missing the correct code to do this. I have tried to create a form off the query by just using the box number and then creating a command button to apply the filter. But this doesn't work. I'm sure that I'm missing a step along the way. Help!

 

[le888]

See attachement...

Hope this help,

Le

 

[dannileeb]

Le,
Thanks for the help. It points me in the right direction, but it could be my total lack of understanding of code that is keeping me from this. I need to filter out boxes/tubes that we have sent to storage. There could be 1 to 100 that for a certain job that I need to keep track of. I'm trying to get it to filter into a report. I'm including a sample of what I am working on. Thanks so much!
dannileeb