How to modify report based on input form

[pmatush]

I have a report that shows costs on various projects. The user can use a form to filter on dates, names, regions, etc. In the report there is a date field that the report is sorted on, to show a chronological history of the projects. However, I want the report to be customizable such that the user can select from a combo box in the form whether he wants to use the start date, completion date, or the date of first use of the project.

In the original report, I only included the project start date, so the control source of the report field was 'start date' the same as the field in the contributing query. In the query, i've added fields for all three date types, which are named 'start date', 'end date', and 'first use'. those are the same names i have in my combo box, but when i set the control source for the report field to =[forms]![project totals], it lists 'start date' for each record in the report instead of 'mm/dd/yy' is there a way to tell the control source that the form selection is actually a field, instead of just text? or am i going about this all wrong.

Thanks in advance,


Patrick

[June7]

ControlSource property doesn't work that way. You could put a nested IIf expression in the ControlSource:

=IIf([forms]![project totals]![datetype]="start date", [StartDate], IIf([forms]![project totals]![datetype]="end date", [EndDate],[FirstUse]))