error -2147352567 (You can't assign a value to this object.)

[DC CS]

Hi all,


I am trying to resolve the above error that I receive when opening a report.
Neither the report nor any control on the report is bound. I need to fill the controls with data retrieved from a table.

My code as follows:

On Error GoTo Handler:


Me.RecordSource = ""
'Get Report Data++++++++++++++++++++++++++++++++++++++++
Set Dbs = CurrentDb
SQL = "SELECT * FROM TmpTableResultReg;"
Set Rst = Dbs.OpenRecordset(SQL)
Rst.MoveLast: Rst.MoveFirst


CourseDescr = Trim$(Rst!CourseDescr)
CourseNumber = Rst!CourseNumber
Facilitator = Trim$(Rst!FacilitatorName)
Assessor = Trim$(Rst!AssessorName)
Moderator = Trim$(Rst!ModeratorName)

The error occurs on the line "CourseDescr = Trim$$(rst!courseDescr)". If I comment this line out, the error occurs at the next line.

Even if I place a new text control on the report and try to fill the new control, I get the same error.

What could the problem be?

Thanks

[Edgar]

What are CourseDescr and CourseNumber declared as? What are they supposed to be?

[DC CS]

They are declared in the table as follows:
CourseDescr = Short Text
CourseNumber = Number (Integer)

They are not declared in the report (Using the DIM statement) as the controls are 2 Unbound Text Boxes.

[Edgar]

Before the line that throws the error type this:
MsgBox typename(coursedescr) & vbcrlf & typename(coursenumber)
Let me know what it says...

[DC CS]

Hi Edgar,
See below result.

[DC CS]

Hi E#dgar,
I have created a new Access database on my Laptop and created the table and manually populated the fields.
I then created a report with 3 textboxes, Text0, Text2 and Text4.

I added the code as above and ran the code with the same result. I cannot assign a value. Even if I try to assign a value before any code runs, I get the same result.

Not sure what this means.
Is there a way I can upload this new DB for you to inspect?

Thanks

[xps35]

Why do you use an unbound report If you want to show data from a table?????

[DC CS]

Hi xps35,
The report is complex and I need to do calculations on other controls in the same report. It is just much easier to get the data from the tables and manipulate the data as and when required.

I am also using multiple tables in the report. The data does not have any unique fields that I can link to create a query.

I hope this explains your question.

[DC CS]

Hi all,
I found the problem.

I placed the code in the Report_Open event instead of the Load event.

Thanks for the assistance, and sorry about this mishap. Think I need a break...

[xps35]

I still have my doubts. Without knowing the database and the desired output, it remains difficult to assess what the best solution is.
Look at https://www.accessforums.net/showthread.php?t=70301 to read how to upload your database.