B
Bob V
This Text Box Code on my Report is not quite working, tbOwnerID Control
Source is: =Val(Forms!frmBillStatement!cbOwnerName)
I am getting #Name? Error
Thanks for any Help....Bob
="Last Payment " & Format(DLookUp("[BillDate]","qryAccountStatus","[OwnerID]
= " & Me!tbOwnerID & ""),"d-mmm-yy") & " " &
Format(DLookUp("[PaidAmount]","qryAccountStatus","[OwnerID] = " &
Me!tbOwnerID & ""),"$ #,##0.00")
Source is: =Val(Forms!frmBillStatement!cbOwnerName)
I am getting #Name? Error
Thanks for any Help....Bob
="Last Payment " & Format(DLookUp("[BillDate]","qryAccountStatus","[OwnerID]
= " & Me!tbOwnerID & ""),"d-mmm-yy") & " " &
Format(DLookUp("[PaidAmount]","qryAccountStatus","[OwnerID] = " &
Me!tbOwnerID & ""),"$ #,##0.00")