Call out recordset fields not displayed on report using VBA

[davecripps]

I did some searches through this forum and I did not find any that dealt with this topic, so I am hoping there is a simple solution. -- I have a report which has VBA code behind the Detail_Format(...) event. In the VBA code I would like to call out the value from a field in the report's recordset, but so far I am only able to do this if that field is bound to a textbox control on the report itself. Is there a way to call out a field from a report's recordset using VBA without binding that field to a box on the report?

 

[Mcgrco]

You could add the field in the underlying recordset, give it a text box on the report and make it invisible. Failing that you could use a dlookup of one of the other text fields in report back on to the origional table

 

[davecripps]

I have done the invisible text box, and that does work, but it becomes very cluttered in design mode after awhile. As far as DLookup() goes, I am trying to avoid making another request for data since the data is already there in the linked RecordSource...any other ideas???

-dc