crosstab query question

[Alan B. Densky]

I'm using A 2000. I've created a crosstab query that finds data based on a
date range that I supply just before opening it. The query will add or
remove columns depending on that date range, and it will label the top of
the column with the appropriate dates.The query works perfectly.

One of the fields in the query is a UserName. I want to be able to double
click the Username, and have it open a form and go to that Username's
record.

Of course, queries don't have events like a form does. So I don't see any
way to open my filtered form from a record in the query.

If I base a form on the crosstab query, the field names and the titles at
the top are only good for the specific date range that I used for the query
when I created the form. So unless there is a way to create the form so that
the column titles and field names are dynamic, I don't know how to go about
accomplishing my goal.

Does anyone have any ideas?

Thanks in advance,

Alan

 

[Duane Hookom]

There is a solution for dynamic monthly crosstab reports at
http://www.tek-tips.com/faqs.cfm?fid=5466. You should be able to modify this
to work with a form rather than report.

 

[Alan B. Densky]

Thanks for the tip, I'll take a look!

Alan

There is a solution for dynamic monthly crosstab reports at
http://www.tek-tips.com/faqs.cfm?fid=5466. You should be able to modify this
to work with a form rather than report.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm