Data from record source

[Vsn]

Hello all,

I try to make a report where I need the fields fPersID and fPersName
printed, this goes in a textbox no probem. Now I need, in my VBA code, the
data from the field fTestField to see what the code should do next. I
thought I could get this code like stgX = me![fTestField], this however
gives and error (2465).

I do set the record source for the report as below at the report_open event.

Rsrc = "SELECT fPersID, fPersName, fTestField FROM tblPers"
Me.RecordSource = Rsrc

Can someone tell me how I can get access to the data fTestField without
linking this to a field/text box on the report.

Thx a lot.

Ludovic

 

[Svetlana]

Put your field in your report and make it invisible so you can read it.

 

[Vsn]

Thx for your input, surly this works. I am actually after a bit more elegant
way to do this. I can remember that I did see it done before, just cant
recall it anymore.

Ludovic