Pass mulitple parameters to query from text box

Hi Experts,
I am completly at a loss why this is not working.  I am attempting to return records based on user input from an Oracle 10G database.  I have 2 problems, but they are pretty much the same.  All I am trying to do is pass the value of a text box to a query.  Very simple and have done this thousands of times.  However, this time (first time to do with Oracle 10g) when the query is based on the text box on the form it does not return any records.  I can open the query and type the same value into the where clause and it works like a champ.  The field in the database is just a standard text field, so I am not sure what is going on.  The second problem is fairly similiar, but I am trying to pass multiple values from a text box to the query (some like In("AA", "BB", "CC").  I have the query based on a text box like so: In([Forms]![frmMyForm]![MyTextBox]).  I am populating the text box with a select case statement based on what the user selects from a dropdown.  I have tried populating the text box with just the values "AA", "BB", "CC", In("AA", "BB", "CC") and "AA" OR "BB" OR "CC" but none of these work.  Like the other query, I can go and type these values in the where clause and the query works like a champ.

So what am I doing wrong Experts?  Something I thought would be so simple is kicking my tail at the moment and I sure don't want to leave for the Thanksgiving holiday with my tail whipped :)

Thanks for your helpStart Free Trial