I need a crosstab type form

[Guest]

I have an attendance role that I wish to present in a crosstab type form with
names in left col. and names of functions attended as row headings. Just as
paper attendance roles look. The number of Functions attended can vary from
none to any number. It is based on tblContacts & tblAttendance, linked to
tblContacts through ID & tblFunctions linked to tblAttendance through
FunctionID.
If I make a pivot table form, then, if the number or names of the Functions
has changed, the number or names of columns won’t be correct next time I open
it. I cannot see any way of creating a saved crossstab type form, The only
way I have been able do it is to build the form in code each time the user
uses it. This works OK, but seems a bit long winded. Surely there is a better
way

 

[JohnFol]

I get the impression the style of data entry you want is almost like a
spreadsheet, which unfortunately you cannot replicate with a cross-tab (as
it's r/o)

To do this programatically is possible, but you'd have to dynamically create
and destroy controls.

You could consider using the DataGrid control, but you still have to
manually crete and destroy the columns / rows


No doubt there is some clever stick out there with a simple solution or 3rd
party control.

Best of luck