OPtion Value frames and queies

[k209310]

I have a form that contains two check boxes that are held within an optionvalue frame. There is also a textbox whioch allows a variable search. The text box currently only searchs one field in a table.

Is it possible to have the text box search different fields depending upon the result of the optionValue frame?.

Currently the text box is related to a query. Is it possible to link the frame to the query aswell?

Thanks for reading

chris