Referencing records in datasheet or use recordset

[Shaft]

Hi All,

Could somebody tell me how to reference each individual record in a datasheet or should I populate a recordset with the same results and use that instead.

Any help would be much appriciated, thank you

 

[boblarson]

Can you be a little more explicit with what you are trying to accomplish? The question is a little vague and what you are asking for may be able to be better accomplished in other ways if we know what, exactly, you are needing to accomplish overall.

 

[wallis1905]

Hello, I think I'm trying to do something similar. I have a report, and in its header I want to display field values from a table. This is a different table to the reports recordset. However, the record read from the table depends on a field value from the reports recordset. I presume there is a way to extract field values from the reports recordset, making your code "syncronysed" with the code you are executing on each page event for the report. Instead of as shaft says, pulling in the same recorset , as the reports recordsource sorted in the same manner to allign the two? I think it's the same problem?

 

[wallis1905]

Have tried this

I have tried using,

Dim MyRstReport As Recordset
Dim MyDbs As DAO.Database
Set MyDbs = CurrentDb
Set MyRstReport = Me.Recordset

but it gives an error "This feature is not available in a MDB"

 

[Shaft]

Sorry for the delay in replying it's been a bank holiday weekend only back in work today.

I'll try and explain in more detail what I'm trying to do. I'm making a wages database, and on the timesheet form I've got the timesheet in a subform and the wage critera on the Main form and I want to do calculation on each record of the timesheet using the wage critera and populate another form with the resulting data.

Any help would be much appreciated, thank you