>the present total length for rowsource is 255 chrs
>is there any way of working round this limitation ?

Try creating a view with all the fields/primary where conditions and then select * from viewname