Making seleced item in a list box a title in the report

[gem28]

Hi! I'm making a database that filters information from a table (imported from MS Excel). I used a listbox for filtering. Since the records are too many in a report, it's difficult to identify without the title of the kind of filter.
How can I make the selected criteria from the list a "title" in the header portion of the report. I tried using a textbox but it does not have a "value" object. Please heelllpppp, pretty please....

...also, how can I add the date of the last revision of the record in the footer area of the form?

thanks so much!

 

[danvlas]

Pass the filter to a textbox on the form prior to opening the report.
Use report's Open event to set the caption of a label:

Me("LabelName&quot.Caption = Forms("YourFormName&quot("TextBoxName&quot

Last revision date...create a field in the underlying table and set it to Date whenever changing something in the record (BeforeUpdate event of the form)

Me("RevisionDate&quot = Date

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html