setting report field equal to form field

  • Thread starter Thread starter T Best
  • Start date Start date
T

T Best

Hi all,

Is it possible to set a field in a report to a field on an open form thru
code? For example...I have a report and i set the On Open Event Procedure as
follows:

Private Sub Report_Open(Cancel As Integer)

txtPolNumber = [Forms]![frmMain_CommPkg]![txtPolNumber]

End Sub

when i open the report i get the following error: Run-time error '2448': You
can't assign a value to this object.

if i set the value of txtPolNumber in design view to
"=[Forms]![frmMain_CommPkg]![txtPolNumber]" it works.

Any help would be very appreciated!
TIA
Ted
 
Back
Top