Which Report Event do I use?

[sanderson]

Hello:

I am trying to get a report to use data on a form, and need to know which report event to put this information on. I am getting all kinds of setfocus errors and other things.

    If Forms!frmTimeCard.txtSS = 1 Then
        txtSupID.ControlSource = Forms!frmTimeCard.txtEmpID
        
    Else
        txtSupID.ControlSource = Forms!frmTimeCard.txtcharacter06
                
    End If

Thanks!

[pbaldy]

To set a control source I'd use the open event, but is that what you're doing? Do the form controls contain field names? Or are you trying to use the form values in the report? If so I'd use the load event or the format event of the section containing txtSupID.

[sanderson]

I tried the format event on the report page header, which produces runtime error 2191, cannot set the control source property in print preview or after printing has started.

[June7]

Cannot set ControlSource property of textbox on report (can on form).

If you want the values from the form controls, expression in textbox ControlSource:

=IIf(Forms!frmTimeCard.txtSS = 1, Forms!frmTimeCard.txtEmpID, Forms!frmTimeCard.txtcharacter06)

But why do you need to do this? What is txtcharacter06?

[pbaldy]

Cannot set ControlSource property of textbox on report (can on form).

Not true, though I don't know if it's required here.

[pbaldy]

I tried the format event on the report page header, which produces runtime error 2191, cannot set the control source property in print preview or after printing has started.

Are you trying to set the control source to a different field name, or just put a value in the textbox. If the latter:

txtSupID.Value = Forms!frmTimeCard.txtcharacter06

[DrGUI]

Try the following:

If Forms!frmTimeCard.txtSS = 1 Then
txtSupID.value = Forms!frmTimeCard.txtEmpID
Else
txtSupID.value = Forms!frmTimeCard.txtcharacter06
End If

I am assuming that the txtSupID are text boxes in the Detail section of your report. If that is the case, put your code in the Detail_Format event of the report.