Command Button Parameter report?

[JonEx]

I have a form and ive placed a command button on it now id like that when you click the command button it will generate a report based on a parameters within the form.
so for example if i wanted 1 customer's contact information to be displayed on a report what code would i have to use ?
ive used a code like this before but with a comboselect box
the code for the reports source was
SELECT tblTravelTry.ClientID, tblTravelTry.MembershipNo, tblTravelTry.Name, tblTravelTry.City, tblTravelTry.ChapterName, tblTravelTry.EMail FROM tblTravelTry WHERE (((tblTravelTry.ClientID) Like [forms]![frmTravel]![cboSelect]));

 

[selavarti]

Hi
This is what I have used for my tables..i donno ur table structure so see this

SELECT tbl_tools.rfi, tbl_tool_type.tool_type, tbl_tools.tool_barcode
FROM tbl_tool_type INNER JOIN tbl_tools ON tbl_tool_type.tool_type_auto_number = tbl_tools.tool_type_auto_number
WHERE (((tbl_tools.rfi)=[forms]![frm_toolrpt]![combo16]));