Cross Tab Query on Form

[Brennan]

I have a cross tab query that is displayed on a form tied to the table that
houses the raw data for the cross tab query. Each line in the cross tab
query comes from 3 lines in the table - one for each month in a quarter. In
the past, I would use the value in the listbox to filter for that record. I
would like to create a similar filter for the cross tab query. How do I
build the query and put it in a listbox so that when someone clicks that row,
it brings the records to the form so they can be changed/ edited? Thanks for
your help.

Brennan

 

[Arvin Meyer [MVP]]

You do understand that Cross-tab queries are uneditable. They can be
displayed in a subform. If the lines in the cross-tab were unique records in
a table, you could retrieve and edit them, but you need to have some unique
criteria to bring a specific record or records to a form to edit.