greensleeves149
Member
- Local time
- Tomorrow, 00:34
- Joined
- Feb 27, 2022
- Messages
- 49
Hello all,
I have a Combo box (ProductName) on a continuous form (this form will be used as a subform) and what I was trying to do, was when the user updates/selects a Product, the respective UPC, Size and Variety fields will automatically populate for that line item. I'm not sure how to approach this on a continuous form- I tried putting a filter on the "product" on the query that runs the form, but that clearly doesn't work.
Would someone please enlighten me how to do this? I've attached a sample database to hopefully make things clearer- but please let me know if you need more information.
Thank you.
I have a Combo box (ProductName) on a continuous form (this form will be used as a subform) and what I was trying to do, was when the user updates/selects a Product, the respective UPC, Size and Variety fields will automatically populate for that line item. I'm not sure how to approach this on a continuous form- I tried putting a filter on the "product" on the query that runs the form, but that clearly doesn't work.
Would someone please enlighten me how to do this? I've attached a sample database to hopefully make things clearer- but please let me know if you need more information.
Thank you.