I have two tables (Vendor and Notes). Each note is associated with a vendor. When entering notes I want to be able to link a string of associated notes together using the subject field on then Note table.
For the row source I want query all note subjects associated to the vendor the note is being created for. The vendor is specified when I start the form (Control Source is "VendorID") then later I want to have the combo box only show subjects used on past notes for that vendor.
Any suggestions?
For the row source I want query all note subjects associated to the vendor the note is being created for. The vendor is specified when I start the form (Control Source is "VendorID") then later I want to have the combo box only show subjects used on past notes for that vendor.
Any suggestions?
