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:
The error occurs on the line "CourseDescr = Trim$$(rst!courseDescr)". If I comment this line out, the error occurs at the next line.Code: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)
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