I have a continuous form which has the following fields:
Code Description Quantity
Code is a combo box with a list of values from an underlying table. When I select a particular code I need the relevant description to appear in the Description field.
I have managed this much by inserting the following code into the AfterUpdate Event of the Code combo box:
Description = Code.Column(1)
However the problem is that because it is a continuous form when I select the next code to enter on the following line, the Description field from all the previous entries on the form changes to the description associated with the code that is being selected.
How do I remedy this so that each line of the form has a description field that only associates itself with the value for the code on the same line?
If this makes any sense, I would love if someone could help me out!
Thanks,
Liam
Code Description Quantity
Code is a combo box with a list of values from an underlying table. When I select a particular code I need the relevant description to appear in the Description field.
I have managed this much by inserting the following code into the AfterUpdate Event of the Code combo box:
Description = Code.Column(1)
However the problem is that because it is a continuous form when I select the next code to enter on the following line, the Description field from all the previous entries on the form changes to the description associated with the code that is being selected.
How do I remedy this so that each line of the form has a description field that only associates itself with the value for the code on the same line?
If this makes any sense, I would love if someone could help me out!
Thanks,
Liam