Interesting Issue With Report

[dynamictiger]

Hi All

I have a report content that is dynamic and changes constantly. To acheive this I have coded the onformat event to add the data via recordsets. This works fine.

The recordset adds a record to a string the string is then all placed into a textbox on the report and there is the task list. the task list is used by service people.

In an ideal world it would be nice if the service people could have a check box or similar to tick to show they have completed the task. I am not sure how to add this programmatically.

So in summary the result I am looking for is:

1: Some task

Task Description Tick here for complete

The code I am using is something like:

Do Until .EOF
 
            If Not .Fields("taskRoot") = "tlkupPoolFeature" Then
 
                strTask = strTask & intCount & ":  "
 
                strTask = strTask & dpsLookup("Task", .Fields("taskRoot"), "ID = " & .Fields("Task"))
 
                strTask = strTask & vbCrLf & dpsLookup("TaskDescription", .Fields("taskRoot"), "ID = " & .Fields("Task")) & vbCrLf & vbCrLf
 
            Else
 
                Call dpsPoolFeature(intCount, .Fields("task"), strTask)
 
            End If
 
Me.txtTaskList = strTask

[Datagopherdan]

Is this just a report that you're printing out and you want a check box next to each task for them to be able to check? If so, just add an unbound check box to your report in the section that would display each task. It will create a check box for each one of them.

Dan