I have a form called frm_Customer. Inside of this form, two subforms are linked. One subform is called frm_HWQuote and the other is frm_SWQuote. What happens is this...I open the frm_Customer, search on my customer, select the customer and then aprox. 6 fields of information appear such as contact name, phone, etc.. Below the subform information is waiting on entry. I fill out completly my subform information for a HW Quote. The only problem...I have my print preview button on the form, not the subform. Therefore, every hardware quote (regardless of customer) prints to the screen. I would like it to print just the HW Quote for the customer I searched for. Any thoughts?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Printing from Sub-Forms
- Thread starter rlh777
- Start date
Hi,
It's not because the button is on the form (as opposed to sub-form), but because the report has been told to print all records from the outer form.
You need to add a 'where' in the query where customer id = current customer id.
Regards,
Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk
It's not because the button is on the form (as opposed to sub-form), but because the report has been told to print all records from the outer form.
You need to add a 'where' in the query where customer id = current customer id.
Regards,
Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Solved