using variables in reports, runtime error: 2147352567

[Bobnz]

using variables in reports, runtime error: 2147352567


I get the above error when I try to preview a report, also says "cant assign value to object".
I have a report with controls that I want to assign values to using variables.

the variables are global so...

txtcontrol = variable in open event of report should work?

B

 

[RoyVidar]

Try to assign the values in the on format event of the section where the controls reside in stead.

Roy-Vidar

 

[Bobnz]

I'm using access 2000 and there isn't an onformat event, not in the properties window for the report nor in the codeview of the report.

thanks for the reply though

B

 

[Bobnz]

I found the onformat event its a section event not a form event.

Still wouldn't accept the variable values.

B

 

[RoyVidar]

Without knowing what you're trying to do, it's hard to guess. More info, current code, what you wish to achieve, is the controls bound or calculated, are the publics real publics or are they defined within a forms/reports module, do they have any value when this is run... (some hints on how to get the most out of the membership and how to get the best answers, may be found here faq181-2886, #14 is perhaps relevant)

Roy-Vidar

 

[Bobnz]

Thanks for the reply Roy, I have found a way around the problem. The report is based on a query, In the query I used functions in the criteria part of the field to return the values needed

jnum is the global variable

Function return_jobnumber() As String    
    return_jobnumber = jnum    
End Function

B