Detail_format event?

[CHAOSinACT]

to make it simple if i have a report with an unbound control where the heck do i put this:
Report_rptCivilJobs.txtCivilJobNumberDisplay.Value = "001"

normally would go in form_current but need it to process for each detail in report (assume "001" would be some code generating that number) i've tried putting it and other code every where nothing seems to affect report detail...only the bound fields show up....

Ideas? questions? comments? lol...

Thanks in advance.

 

[CHAOSinACT]

lot of vba processing form many unbound controls, better to just be able to do it all from code... not sure all my dsum()s and such will fit there

 

[CHAOSinACT]

lol ok idea but only works for first record in report anyway....

 

[CHAOSinACT]

this is so frustrating works for 1 record report only...

 

[vbaInet]

Still not working? Please elaborate

 

[CHAOSinACT]

ok i'll be more verbose - i tried to keep it simple lol. somehow it never is...
i have a project management database. over 100 projects in it. the main form loads relevant details from table for half the fields but rest are unbound controls. they calculate and load data from a range of queries and summations and project to unbound controls for each project as it loads in the form_current event. NOW, if i try to make a report that shows ALL the projects together with these unbound controls the Current event isn't relevant. i would THINK i would put it in detail_format for each record to calculate, but i would be wrong....

 

[CHAOSinACT]

OMG i think the syntax was subtly stuffed. so stupid...almost embarrased to mention it lol. however format works in print preview only...is there an event to format before print preview? i can just jump user to there anyway...

 

[PNGBill]

You have a Single Form and want the unbound Controls to influence the data in a multi record report?

If this is the case then wouldn't you need to have a query select the data for each record the report requires and reference to the Unbound controls in your form as it does so. Otherwise, presumably the from is just for One record and the Unbound Controls are just controls on this single form.