title: VFP - Control report from form
body: <p>iam using VFP 9.0...Iam making an invoice report, what i want to know is how to change the contents of the report by changing lets say a combo box in a form. or be able to use select and where clause in the report...any help would be appreciated :)</p>
  
  <p>EDITED FOR CLARIFICATION (per comments instead of direct add into question)</p>
  
  <pre><code>+-----------------+       +-------------------------+
  |  Contract Form  |       |   Invoice Form          |
  |                 |       |                         |
  |                 |       | radioCustomer           |
  | btnInvoiceForm -------&gt; |    comboCustomersList   |
  +-----------------+       | radioContract           |
                            |    comboContractsList   |
                            |                         |
                            | btnPreviewReport        |
                            +-------------------------+
  </code></pre>
  
  <p>If I click on the Preview Invoice button, show all records from contract table where customer id (FK) is = to the id picked from the combo box. </p>
  
  <p>If I picked contract from the radio buttons, the contract combo box would work, showing a list of contract id(s), running the report then would show you the record from the contract table where contract id = the id picked from the combo box...</p>