Confuseduk
Registered User.
- Local time
- Today, 00:10
- Joined
- May 25, 2019
- Messages
- 11
Hi
I have a working database my work (self employed driver).
Up to now I have been using a hand written form to record my jobs but I would like to have all this computerized.
I have a Customer Table (CustT) with Customer Details And a Job Table (BookingJobT) with Details of my runs.
My relationship is a one to many between [CustT] [CustID]and [BookingJobT] [BookingJobID].
I have a working form (thanks to some help from Mike60Smart) which has customer details as the main form with a subform within for the job details.
To display my jobs I can Select Customer and cycle through that customers jobs using the navigation keys.
I have designed a Report to display the results as per my old written forms via a print button on the customer form.
However every time i try to print the job my printer prints a list of each of that customers jobs.
How do I program the button to print only the job that is on display on my screen with its heading?
Thanks.
I have a working database my work (self employed driver).
Up to now I have been using a hand written form to record my jobs but I would like to have all this computerized.
I have a Customer Table (CustT) with Customer Details And a Job Table (BookingJobT) with Details of my runs.
My relationship is a one to many between [CustT] [CustID]and [BookingJobT] [BookingJobID].
I have a working form (thanks to some help from Mike60Smart) which has customer details as the main form with a subform within for the job details.
To display my jobs I can Select Customer and cycle through that customers jobs using the navigation keys.
I have designed a Report to display the results as per my old written forms via a print button on the customer form.
However every time i try to print the job my printer prints a list of each of that customers jobs.
How do I program the button to print only the job that is on display on my screen with its heading?
Thanks.