I have been asked to build a report that will identify each time a specific option has been sold however I'm struggling with how to setup the report criteria.

Our option numbers consist of a 9 digit number. The the first four characters vary from house plan to house plan however the last 5 are the same and indict the specific option. An example would be 109115055 and 108115055. These are two separate plans but both have the same option installed.   

I would like to design a report where the user could simply input the option number (Ex. 15055) and the report would spit out EACH time a specific option has been sold.

Any suggestions would be greatly appreciated. Thanks!

I've been playing with your suggestion but I can't seem to get the syntax right and get the dreaded "Remaining text doesn't appear to be part of the formula" message. My current Record Selection Formula is
{VW_AMA_Est_Options_w_Job.OPTION_NUMBER} = {?Option Number} Obviously this is not accurate but shows what my table and Parameter field are. Given than how would you would you proceed? Many Thanks!

Ah! Is see now. Thank you so much. I owe you lunch or a coffee if you are ever in Charlotte, NC.