lookup tables and querys

i'm writing a query for a travel company database.
it consists of querying to find out which clients has booked with selected companys.
the comapnys are selected from a form which has 4 lookup boxes on it (cruise1, cruise2, cruise3, cruise4) these update to a table multiplecruises,
the table keeps the primary key number of each selected cruise.
i've written the query and it works except that it won't take the data from multiplecruises
ie
WHERE CruiseData.CruiseOperator = MultipleCruises.Cruise1 or CruiseData.CruiseOperator = MultipleCruises.Cruise2 and so on.

is this possible or do i have to find a way around it?

at the moment when i run the query it askes me to input values for cruise1-4 nd then works fine, i need it to take values from my table.

Did you try use AND
CruiseData.CruiseOperator = MultipleCruises.Cruise1 AND CruiseData.CruiseOperator = MultipleCruises.Cruise2

i don't think its the operator thats the problem, it asks me for all the values cruise 1-4 then it will run the query and i get the expected results
i'll post the code when i get back to a machine with access on it