Greetings and salutations!

I have a form to enter data that tracks attendance at a function. As
in, this grandparent attended this seminar. I have a sub-query that
shows the grandchildren connected to that grandparent. And it works
great. But....

What I would actually like is a sub-form/query that instead allows me
to see the list of grandkids with a check box for each grandchild so I
can click in it and select the grandchildren who also attended. I
want it simple like that because there will be a lot of volunteers
entering data and the less they have to touch the better. (In the
end, the counts of WHO attended WHAT are used to support funding/grant
requests. You know, red tape.)

I have tables for grandparents, grandchildren, and event attendance
tracking.

I'm not a programmer by any stretch, and so as a self-taught hacker I
work in design view as much as possible because it's all I know. If
there is a workable solution in design view I'd be grateful. If there
is a coding solution then I guess I'll learn something.

Any help or direction will be be greatly appreciated. I'm stumped and
frustrated. Good reason to drink beer, but not conducive to making
progress on something the non-profit wants to start testing in two
weeks. Yikes. And this is the last thing I need built of
course.....so close and yet so far. ))

Thank you in advance.

Mrs. Rum

If you have a tables for events, grandparents, grandchildren and
eventattendance and if the
eventattendance table has eventid, grandparentid, grandchildid and you
basically expect EITHER grandparentid OR grandchildid to
be populated along with the eventid then you could use two separate subforms
(one for grand parents and one for grand children) on the event screen (both
are linked by the event screen) and each one has a dropdown to select a
grand parent or grand child, you then add rows to add new grand parents or
grand children.

You can do check boxes but that would be trickier and you would need some
code, subforms are designed to work that adding records adds new records to
the table (without code).

On another note you might want to take a look at my donation software it has
event tracking and works slightly differently in that
everyone is considered a contact and you can relate contacts to other
contacts (so grand children can be related to their grand parent etc...)
you then use contacts for all kinds of things.

It might help you out with ideas, it's done in Access.

There is also a simple event tracking template on Microsoft's site (it's
very simple).

If you have multiple people sharing a database you want to split the
database and use linked tables so you have multiple front-ends (one for each
user/computer) and one shared front-end.
--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"MrsRum" <mrsrum (AT) gmail (DOT) com> wrote