Crosstab not accepted as subform

[gazzieh]

I have a set of data I want to display as a matrix.

Along the top are three column headings (P, M, D).


In the first column are the row references, which are numbers 1 to 10.
Where these row and column references cross is a lot of text.

Basically I can then identify P1, M3, D5 etc (battleships in a way).

I have created this as a crosstab query with no issues.

The key field for this query is set as unit_id (NOT used in the actual crosstab table but I can set this to, say, 44 and the table shows the results for course 44).

I have a form that lists all the courses and has the key field unit_id.

If I try to embed the query into the form the system proposes connecting unit_id to unit_id but then says it is not in the query. If I set to define my own I find that, sure enough, the unit_id query is not showing - though it IS in the query.

What can I do to connect the form to the crosstab query using the key field unit_id?

[Rod]

Perhaps it's not possible to use Access Master/Child Fields linking in this situation. I don't know and neither does anyone else judging by the time this post has been unanswered.

You probably have to resort to using VBA to synchronise your subform. If you want help with that publish your crosstab SQL and give us the name of the control on the master (parent) form that contains the unit_id value. We can then use your names in any response.

[gazzieh]

Actually I solved this a little while ago. I had to use the Column Headings property and then could define the relevant hidden row value. This then allowed the query itself to be used as a subform - viewable as a datasheet.

I now need to use VBA to tidy up the view but that part is easy!