D
dansoper
I am trying to get something working, and not sure if it is
possible....
I am building a database of people who are members of several groups.
Their membership is validated each year, so there is a field for each
group, into which the last year of validation goes.
I want a report that prints a list of members of each group, but don't
want to create one manually for each group, as the design is exactly
the same. I got quite far in automating it, with a form which selects
the group, but I cannot make it print the year of the relevant group.
The report shows various common details, but obviously for each group I
want to display the validation year for that specific group per
person.
Understand me? Is there any way? So far, my form creates [forms]![(my
form name)]![GroupName]. I want to be able to print into the report
the contents of the field with the same name as the value of
[GroupName].
I look forward to any help.
Thanks,
Dan Soper
possible....
I am building a database of people who are members of several groups.
Their membership is validated each year, so there is a field for each
group, into which the last year of validation goes.
I want a report that prints a list of members of each group, but don't
want to create one manually for each group, as the design is exactly
the same. I got quite far in automating it, with a form which selects
the group, but I cannot make it print the year of the relevant group.
The report shows various common details, but obviously for each group I
want to display the validation year for that specific group per
person.
Understand me? Is there any way? So far, my form creates [forms]![(my
form name)]![GroupName]. I want to be able to print into the report
the contents of the field with the same name as the value of
[GroupName].
I look forward to any help.
Thanks,
Dan Soper