hi, all
I have two tables tblCustomerCredit is the main talbe and tblCustomerPaid is the subtable.

In the Dataenvironment of VB i have add tblCustomerCredit is main command and tblCustomerPaid is child command.

and In my datareport it can work with all the records, but i want to display those record by condition (Ex. by CustomerName).

here my SQL statrment:

Private Sub CmdPrintData_Click()
Dim Str As String
Str = "Select From tblCustomerCredit.*,tblCustomerPaidDetail.*" _
& " INNER JOIN tblCustomerPaidDetail On tblCustomerCredit.InvoiceNumber=tblCustomerPaidDetail.InvoiceNumber"
DataEnvironment1.rstblCustomerCredit.Open Str
RptCustomerCredit.Show
End Sub

so can i using where clause to display those recordsby condition?


____________________________
need for your help

hello,

try looking at this post by TJ_01.. i think it can be of help...

http://www.andreavb.com/forum/viewtopic.php?TopicID=6229&page=0#20864
  


andrew