Microsoft Access Expert 22

Microsoft Access Expert 22
By Richard Rost

8 years ago

OrderDetailF Upload Images Link
Ryan W
6 years ago

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

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Microsoft Access Expert 22 Comments