Hi there,
I'm new in MS Access and I know the golden rule about searching for an answer prior creating a post, but I could not find anything helpful.
My problem is as follows.
I have 2 tables ComponentsT (with fields - ComponentID, comCode, comName and comPrice) and ComponentListT (with fields – ComListID, ComponentID and comlistQty), with two forms ComponentsF (Single Form) and ComponentsListF (Continuous Form).
My goal is to have list of components on that continuous form where I want to calculate comPrice*comlistQty in unbound textbox (txtTotalCompPrice) for each row. This works, I am using =[txtComponentPrice]*[comlistQty] (where txtComponentPrice is textbox taking its value from combobox – contro source is set to =[ComponentID].[column](3)).
However, when I try to calculate SUM in the cont. form footer for the textbox mentioned above I will get #Error. I am using this =Sum([txtTotalCompPrice]).
Attached is my DB file (MS Access 2013).
Thanks in advance for any help you can provide,
Martin
I'm new in MS Access and I know the golden rule about searching for an answer prior creating a post, but I could not find anything helpful.
My problem is as follows.
I have 2 tables ComponentsT (with fields - ComponentID, comCode, comName and comPrice) and ComponentListT (with fields – ComListID, ComponentID and comlistQty), with two forms ComponentsF (Single Form) and ComponentsListF (Continuous Form).
My goal is to have list of components on that continuous form where I want to calculate comPrice*comlistQty in unbound textbox (txtTotalCompPrice) for each row. This works, I am using =[txtComponentPrice]*[comlistQty] (where txtComponentPrice is textbox taking its value from combobox – contro source is set to =[ComponentID].[column](3)).
However, when I try to calculate SUM in the cont. form footer for the textbox mentioned above I will get #Error. I am using this =Sum([txtTotalCompPrice]).
Attached is my DB file (MS Access 2013).
Thanks in advance for any help you can provide,
Martin