Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Collection List from From to Report

Status
Not open for further replies.

itsecsol

Programmer
Dec 31, 2001
9
0
0
US
I have a form w/ a list of checkboxes. When selected the a calculation is performed. I need to list the selected checkboxes in a list on my report.

I have a forall loop to 'grab' the selected checkboxes:
//////////////////////////////////////////////////

Function fi_Region_Count
Dim xCount As Integer
xCount=0

'Messagebox currentdocument.frmFirmIndiv.objectlist.count

Forall xCheck In CurrentDocument.frmFirmIndiv.ObjectList
If Left(xCheck.name,6)="region" Then
If xCheck.IsChecked Then
print xCheck.name
End If
End If
End Forall

'Messagebox xCount, MB_OK
fi_Region_Count=xCount

End Function
//////////////////////////////////////

I need to get the xCheck values from the form so that I can use the values as a list on my report.

I am greatful for any help that anyone can give.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top