If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unbound Combo Refresh
I have an unbound combo on a form that is summing a value from a subform.
(=sum([project payments]) I need it to update as I change from one record to the next in the main form. The mainform and subform are linked by project #. Thanks!!! -- Milton Purdy ACCESS State of Arkansas |
#2
|
|||
|
|||
Unbound Combo Refresh
me.unboundcombo.requery in the form current event would be my initial
thought... -- Maurice Ausum "golfinray" wrote: I have an unbound combo on a form that is summing a value from a subform. (=sum([project payments]) I need it to update as I change from one record to the next in the main form. The mainform and subform are linked by project #. Thanks!!! -- Milton Purdy ACCESS State of Arkansas |
#3
|
|||
|
|||
Unbound Combo Refresh
Why a combo box? I don't see where a drop-down list fits into this. You
could place the appropriate expression In a text box Control Source. In the subform footer you could have as the Control Source for an unbound text box (txtSum): =sum([project payments]) This assumes [project payments] is a field in the subform Record Source. You should be able to hide the text box and reference it in a main form text box Control Source: =Forms![FormName]![SubformControlName].Form!txtSum You could also perform the sum directly in a main form text box: =Sum(Forms![FormName]![SubformControlName].Form![project payments]) There should be no need to requery or otherwise force an update. It should produce the result for the current record (including related subform records). I have never tried summing in a combo box , but I expect it could work the same way. golfinray wrote: I have an unbound combo on a form that is summing a value from a subform. (=sum([project payments]) I need it to update as I change from one record to the next in the main form. The mainform and subform are linked by project #. Thanks!!! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201003/1 |
Thread Tools | |
Display Modes | |
|
|