First post! I have read similar threads with a question close to mine, yet still unable to solve this challenge
I have attached an image of my form.
I have a purchase order form and a PO details form within.
When the user selects a Vendor from the VendorIDcombo, the combo box in the subform only displays products that belong to that vendor.
The issue is that If the user changes the Vendor I would like the Product code combobox to Requery and only show products related to the new vendor.
I have tried combinations of onclicks events, afterupdates, setting to null etc.
The perfect outcome would be that...
All product codes in the subform would get reset to null if the Vendor is changed, but NOT if the user clicks the combo, but decides not to change the vendor.
Any help would be great.
I have attached an image of my form.
I have a purchase order form and a PO details form within.
When the user selects a Vendor from the VendorIDcombo, the combo box in the subform only displays products that belong to that vendor.
The issue is that If the user changes the Vendor I would like the Product code combobox to Requery and only show products related to the new vendor.
I have tried combinations of onclicks events, afterupdates, setting to null etc.
The perfect outcome would be that...
All product codes in the subform would get reset to null if the Vendor is changed, but NOT if the user clicks the combo, but decides not to change the vendor.
Any help would be great.