Hi guys,
I searched around and couldn't find any good responses so here I go.
I have a Main form with a Sub form, Main form has Contact data. I use a combo box to go from one Contact to another, of course each contact has a ContactID. My Sub form has Proposal data, I use a combo box to select a date in which the proposal was created.
My mission is to print a report based on the Contact (LnameFname) selected and ProposalDate selected from my subform.
It was easy enough to print a report based on the ProposalDate selected when I open up the subform on its own window, not so easy when I try to print it from the Main form. In my tblProposals I have created ContactID and linked them both on my Main form. Please let me know how I can achieve this.
Also, I have an additional question. As you now know, I said that each proposal has a ProposalDate. I also need to find a way for my combo box to display all proposal dates ONLY based on the Contact selected on my main form. (Right now its displaying all proposaldates, regardless of what contact i select on my main form)
All/any help is greatly appreciated!
I searched around and couldn't find any good responses so here I go.
I have a Main form with a Sub form, Main form has Contact data. I use a combo box to go from one Contact to another, of course each contact has a ContactID. My Sub form has Proposal data, I use a combo box to select a date in which the proposal was created.
My mission is to print a report based on the Contact (LnameFname) selected and ProposalDate selected from my subform.
It was easy enough to print a report based on the ProposalDate selected when I open up the subform on its own window, not so easy when I try to print it from the Main form. In my tblProposals I have created ContactID and linked them both on my Main form. Please let me know how I can achieve this.
Also, I have an additional question. As you now know, I said that each proposal has a ProposalDate. I also need to find a way for my combo box to display all proposal dates ONLY based on the Contact selected on my main form. (Right now its displaying all proposaldates, regardless of what contact i select on my main form)
All/any help is greatly appreciated!
