Hi I have a query that feeds into a report. The field names in the query change depending upon criteria chosen by the user. e.g. the user may select to view data from years 2004, 2005 and 2006... but they might select different years etc.
The query is a crosstab so I'm wondering how can I tell my three 'year' textboxes where to get their data from? At the moment the control sources for the three boxes on the report are 2004, 2005 and 2006... how can i change these to whatever i want them to be? I guess it'll be using the on open rport event?
Cheers in advance
The query is a crosstab so I'm wondering how can I tell my three 'year' textboxes where to get their data from? At the moment the control sources for the three boxes on the report are 2004, 2005 and 2006... how can i change these to whatever i want them to be? I guess it'll be using the on open rport event?
Cheers in advance
