Well to xplain a little the code i just put sort of builds the queries and combines them whereby different tables in the oracle DB are joined to produce a result. then i have a command button(actually named Search) which then sort of call this function. the search function looks like this