Making my first database and I think I may be in over my head slightly. So far I think I've managed to stumble through the creation of this DB.
The issue that I am struggling with is this....
I have a main form, frmQuote, there is a subform located in the main form called frmRevision. I am trying to have the subform (frmRevision)display the record based on the QuoteNum which is the primary field for the table associated with frmQuote. I think I may have got this far.
The problem comes when I try to filter the subform based on the revision combobox in the frmQuote form. How do I do this? :banghead:
I've attached the DB for reference.
Thank you.
The issue that I am struggling with is this....
I have a main form, frmQuote, there is a subform located in the main form called frmRevision. I am trying to have the subform (frmRevision)display the record based on the QuoteNum which is the primary field for the table associated with frmQuote. I think I may have got this far.
The problem comes when I try to filter the subform based on the revision combobox in the frmQuote form. How do I do this? :banghead:
I've attached the DB for reference.
Thank you.
