New to VBA Please help

[pbuddy_8]

Hello,

I'm new to VBA so want some help in MS Access. I've made three tables

Company
Order
Transaction

Company contains all details of company. Order contains bill no, bill date and total bill amount and Transaction contains Sno,Particulars, rate, qty and amount. I've set the respective relationships i.e. one-to-many between Company and Order and one-to-many between Order and Transaction. I've made a order form with transcation sub form so that I can enter whole bill details and save it to the tables. Now I want a print preview of this using report so I made a report and kept a Preview Report button on the Order Form. But, it shows all records from the table the thing I need is that it should show the records from the current bill.