1. add textbox and command1 in a Form
2. add label1 and set a caption "Bill No"
4. add dataenvironment1
5. Set connection1 in Dataenvironment of your database file name
5. add command1 in Dataenvironment and type a query in sql as following example
SELECT * FROM BillTable WHERE Billno = ?;
6. Design a report of Datasource : DataEnvironment1 and Datamember Command1
7. Add Click Event of Command Button in Form
Private Sub Command1_Click()
If Dataenvironmanet1.Connection1.State<> 0 Then
8. Run This Program
9. Type a bill No in Textbox
10. Click on Command1
You can See only selected BillNo Report
Last Wiki Answer Submitted: January 8, 2010 4:20 am by Jadejaashok60 pts.