Cross Tab Query on Form

  • Thread starter Thread starter Brennan
  • Start date Start date
B

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
 
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.
 
Back
Top