markswan20
Technical User
Good Evening all.
I have a table that uses 2 columns one for descripion and the other for cost. This is linked to a bombo box on my form that automatically updates the price using this table.
My problem is this, i am trying to create a second form that allows me to change the price of each item on one sheet now as they are in the columns it acts like multiple records. I have come up with the idea of copying the individual prices on to one line within the same table but unfortunatly i'm a little unsure of how to make the cells link to one another.
is this possible and if so could someone kindly elaborate on how?
Kind Regards
Mark
I have a table that uses 2 columns one for descripion and the other for cost. This is linked to a bombo box on my form that automatically updates the price using this table.
My problem is this, i am trying to create a second form that allows me to change the price of each item on one sheet now as they are in the columns it acts like multiple records. I have come up with the idea of copying the individual prices on to one line within the same table but unfortunatly i'm a little unsure of how to make the cells link to one another.
is this possible and if so could someone kindly elaborate on how?
Kind Regards
Mark
