Hi Friends!

Here's my situation:

I have a text box, 3 radio buttons , and a datagrid. I am trying to do a search of a database with the ability to do it three separate ways. The user would type in keywords in the textbox and then select one of the three radio buttons (let's call them title, subject, IDnumber) I want to run the search based on the text and the selected radio button, so how do I go about doing this. I know that I need to change the recordsource at runtime but I need to get it working. I would also like sample code or links to resources, if possible. Thanks in advance.