Hi Alex. Thanks for your reply. I actually submitted a comment/question twice by accident. On the first one I accidentally pressed enter instead of backspace, submitting it before my question was complete. My second comment/question was more detailed. Is it possible to possible to have a ProductCombo in the detail section that is not directly tied to (or live with) the ProductT such that price changed in the ProductT do not effect all the orders? And if the answer is yes, when/where is this taught? In advanced/VBA lessons?
Reply from Alex Hedley:
I think its 302 How to get a value from a Combo box and put it into another Field. You would need to create another Field in the Table that is static, then have an AfterUpdate on the Product and put that value from the Product chosen into your Purchased Fields. You could do this with some Forms!FORMNAME!FIELDNAME = x etc
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.