cross-tab query in sub-form

[Guest]

I'm a very new user who is developing an inventory form...with a sub-form.
The form portion contains an item# (just to keep things simple) and the
sub-form will contain the ready week# and on hand quantity, that will be
input regularly. The ready week# is variable (not all 52 weeks need to
appear in the sub-form) so only those ready week#'s where there is an on hand
quantity needs to appear. Doing a cross-tab query works fine but it appears
that Access does not allow you to create parent/child relationships in
sub-forms using cross-tab queries. Instead it is looking for "fixed
columns". I'd like each ready week# to become an individual column and the
on hand qty to fall under each ready week# (much like how you'd orient using
an excel or access pivot table). Any insight on how to accomplish this would
be very much appreciated.

 

[Wolfgang Kais]

Hello Matt.

I'm a very new user who is developing an inventory form...with a
sub-form. The form portion contains an item# (just to keep things
simple) and the sub-form will contain the ready week# and on hand
quantity, that will be input regularly. The ready week# is variable
(not all 52 weeks need to appear in the sub-form) so only those
ready week#'s where there is an on hand quantity needs to appear.

So why use a crosstab query? How does it look like?

Doing a cross-tab query works fine but it appears that Access does
not allow you to create parent/child relationships in sub-forms using
cross-tab queries. Instead it is looking for "fixed columns".

Readthe error message properly: "Use the ColumnHeadings property"
(of the crosstab-query, for example 1, 2, 3, 4, ..., 53).
Use a row heading column as LinkChildFields property for the subform control
and use the name of the item# control in the main form for the
LinkMasterFields property.