Reports Record Set

[playsted]

I currently have a form that performs a search; however, I want the record results of the search to be used in a form that I have already made. Is there anyway to easily accomplish this?

Andy

 

[trevil620]

You can use the search criteria from your search form to create the SQL then set the form recordsource property to that string.

 

[playsted]

I'm sorry, but I meant a report, not a form that I have already made. Is it done in a similar fashion?

 

[trevil620]

I assume your search form has one of more controls (comboBox maybe) that allows you to select the records you want. In the easiest case, let's say you have only one combobox. Simply change your Report recordsource SQL to something like:
SELECT Employee.*
FROM Employee
WHERE (((Employee.Department)=[Forms]![frmSearch]![cboFind]));