Hi All,
I have another question regarding the same database i've been working on.......sorry to keep on asking but they keep coming back looking for silly stuff i can't seem to get to work !.
I've attached the file and if you go to the form Submit A Work Order, add your name and a select a time, then go to the subform a pick an item, i've been asked to add in a cost per item selected.......but it keeps changing every time i select a new line on the datasheet. I need to be able to have different costs for different selections. I tried the OnChange event of the combo box but it only works up to a point. It might just need a tweak to the code but i can't find a solution anywhere ?
I have another question regarding the same database i've been working on.......sorry to keep on asking but they keep coming back looking for silly stuff i can't seem to get to work !.
I've attached the file and if you go to the form Submit A Work Order, add your name and a select a time, then go to the subform a pick an item, i've been asked to add in a cost per item selected.......but it keeps changing every time i select a new line on the datasheet. I need to be able to have different costs for different selections. I tried the OnChange event of the combo box but it only works up to a point. It might just need a tweak to the code but i can't find a solution anywhere ?