Populating report through recordset

[valeryk2000]

I work with SQL Server 2008 with Access 2007 front end (using ADO). I can easily populate form controls using recordset. It does not look like I can do the same with reports. May be I am missing something?
Thanks people

 

[CJ_London]

You can - assign the recordset in the report On Open event

 

[valeryk2000]

And ... is there a way to assign recordset fields to controls (sorry for being so stupid)? THanks

 

[CJ_London]

yes - in the control, set the name of the controlsource to the name of the field - it is also worth setting the same name for the control name as well

If you haven't set a recordsource, not problme, just type in the name