Hey,

I currently have a Data Report, linked to a Data Environment, that displays the following fields:

ProductID
Cost
Price
Profit

It currently displays all of the records from the Product Table. Is there any way so that at run-time when I display the report, it only displays one record, hence only one ProductID? For example:
VB Code:
  1. Private Sub CommandBox_Click()
  2. Load ProductReport Where ProductID= " & txtProductID & "
I'm not sure if this can be done this way (coding in command box), or whether to use the 'SQL Statement' box in the Command Properties of the Data Environment.

Any pointers would be greatly appreciated.
With many thanks!