我需要帮助弄清楚这个公式，或者需要在ACCESS上提出更好的公式的建议

Question

我需要这些公式的帮助，我试过使用这个公式，但它告诉我要延长

=IIf（[Combo5]="建筑服务工程师"，[Forms]！[估算]！[Text787]，IIf（[Bombo5]="木匠"，[Fforms]！[估计]！[TText788]，IIf"[Combo5]="保管人"，[FForms]！[预估]！[Text 789]，IIf[Combo5]="保管人-轮班工资（早上5点-早上6点）"，[Forms]！[估计]！[文本790]，IIf（[Combo5]="电工"，[Forms]！[估算]！[Text791]，IIf（[Bombo5]="设施项目主管"，[Fforms]！[预估]！[TText792]，II夫（[Combo5]="消防队长"，[FForms]！[估计]！[Ttext793]，IIf（[Combe5]="园艺专家"，[FForms]！[估算】！[Text794]，IIf"，[Forms]！[EEstimate]！[Text796]，IIf([Combo5]="灌溉专家"，[Forms]！[估计]！[文本797]，IIf（[Combo5]="劳工"，[Forms]！[估算]！[Text798]，IIf（[Bombo5]="首席汽车/设备技工"，[Fforms]！[预估]！[Txt799]，II夫（[Combe5]="首席保管人"，[Forms]！[估算】！[Text800]，IIf[Combo5]="首席地面工人"，[FForms]！[估计]！[Text 801]，II夫·[Combo5]]="轻型汽车/设备操作员"，[FForms]！[预估】！[Text 802]，IIf-]="Locksmith"，[Forms]！[EEstimate]！[Text803]，IIf([Combo5]="维修技工"，[Forms]！[估计]！[Text804]，IIf（[Combo5]="油漆工"，[Forms]！[EEstimate]！[Text805]，II夫（[Combe5]="害虫防治专家"，[Fforms]！[Eestimate]；[Text806]，IIf（[Combo5]="管道工"，[Forms]！[AEstimate]！[Text807]，IIf[Combo5]="回收工（劳工）"，[Forms]！[估计]！[Text808]，IIf（[Combo5]="制冷机械师"，[Forms]！[Expression]！[Text809]，IIf（[Combo 5]="监督建筑服务工程师"，[Fforms]！[EXPression]；[Text810]，0））））

所以我把它当作一个SWITCH函数

=开关（[Combo5]="建筑服务工程师"，[Forms]！[Eestimate]！[Text787]，[Combo5]="木匠"，[Fforms]！[Estimate]！[Text788]，[Combe5]="保管人"，[FForms]！[EEstimate]！[TText789]，[Compo5]="保管人-轮班工资（早上5点-早上6点）"，[FForms]！[估计]！[Text790]，[Combo5]="电工"，[Forms]！[估计]！[Text791]，[Combo5]="设施项目主管"，[Forms]！[估计]！[Text792]，[Combo5]="消防元帅"，[Forms]！[估计]！[Text793]，[Combo5]="园艺专家"，[Forms]！[估计]！[Text794]，[Combo5]="Grounds Worker"，[Forms]！[估计]！[Text795]，[Combo5]="室内设计"，[Forms]！[估计]！[Text796]，[Combo5]="灌溉专家"，[Forms]！[估计]！[Text797]，[Combo5]="劳动者"，[Forms]！[估计]！[Text798]，[Combo5]="首席汽车/设备技工"，[Forms]！[估计]！[Text799]，[Combo5]="首席托管人"，[Forms]！[估计]！[Text800]，[Combo5]="Lead Grounds Worker"，[Forms]！[估计]！[Text801]，[Combo5]="轻型自动/装备操作员"，[Forms]！[估计]！[Text802]，[Combo5]="Locksmith"，[Forms]！[估计]！[Text803]，[Combo5]="维修技工"，[Forms]！[估计]！[Text804]，[Combo5]="画家"，[Forms]！[估计]！[Text805]，[Combo5]="害虫防治专家"，[Forms]！[估计]！[Text806]，[Combo5]="水管工"，[Forms]！[估计]！[Text807]，[Combo5]="回收工（劳工）"，[Forms]！[估计]！[Text808]，[Combo5]="制冷机械师"，[Forms]！[估计]！[Text809]，[Combo5]="建筑服务监理工程师"，[Forms]！[估计]！[Text810]）

这不起作用，所以我把它用作模块

Option Compare Database
Public Function fncRetValBasedOnCmb4() As String
Select Case Forms!ReportFinished!Combo4
    Case "Building Service Engineer"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text787
    Case "Carpenter"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text788
    Case "Custodian"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text789
    Case "Custodian - Shift Pay (5am - 6am)"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text790
    Case "Electrician"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text791
    Case "Facilities Project Supervisor"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text792
    Case "Fire Marshal"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text793
    Case "Gardening Specialist"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text794
    Case "Grounds Worker"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text795
    Case "Interior Design"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text796
    Case "Irrigation Specialist"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text797
    Case "Laborer"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text798
    Case "Lead Auto/Equip Mechanic"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text799
    Case "Lead Custodian"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text800
    Case "Lead Grounds Worker"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text801
    Case "Light Auto/Equip Operator"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text802
    Case "Locksmith"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text803
    Case "Maintenance Mechanic"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text804
    Case "Painter"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text805
    Case "Pest Control Specialist"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text806
    Case "Plumber"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text807
    Case "Recycler (Laborer)"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text808
    Case "Refrigeration Mechanic"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text809
    Case "Supervising Building Service Engineer"
        fncRetValBasedOnCmb4 = Forms!Estimate!Text810
    Case Else
        fncRetValBasedOnCmb4 = 0
End Select

终端功能

问题是我不知道如何触发这个

---

我有一个输入数据的表格我正在尝试创建一个带有几个组合框的新表单，一旦选中，它将显示未绑定文本框（从第一个表单计算的字段）中关联的金额

Answer 1

如何放置公式：

=fncRetValBasedOnCmb4()

在未绑定文本框的控制源中？