T
Thanes Queenan via AccessMonster.com
I am creating a report and I would like it to count the number of times that
a selected "asset" on my drop down list is used throughout my records and
display the percentage it is used, how would I go about doing this.. so far
all i've been able to get to show up in my report is the number 1 which
corresponds to the first item on my list. How do I get it to display the
actual item name??
I placed this in my report on open code but it comes up with an error : Run-
Time Error: '438'
Am I putting this stuff in the right place??
Private Sub Report_Open(Cancel As Integer)
[Form_Bi Weekly Member Journal]!Assets.ItemData (1)
Me!Assets.Value
If (Me!Assets.Value = "Family Support") Then
FamilySupportCount = FamilySupportCount + 1
End If
End Sub
a selected "asset" on my drop down list is used throughout my records and
display the percentage it is used, how would I go about doing this.. so far
all i've been able to get to show up in my report is the number 1 which
corresponds to the first item on my list. How do I get it to display the
actual item name??
I placed this in my report on open code but it comes up with an error : Run-
Time Error: '438'
Am I putting this stuff in the right place??
Private Sub Report_Open(Cancel As Integer)
[Form_Bi Weekly Member Journal]!Assets.ItemData (1)
Me!Assets.Value
If (Me!Assets.Value = "Family Support") Then
FamilySupportCount = FamilySupportCount + 1
End If
End Sub