I offered to help a friend out with a small database that is meant to track lunch orders for their small private school. It is so simple, I didn't even give any thought to it. It is just 2 tables, one for students, and one for lunch orders. All we are tracking is whether or not a student ordered lunch on a given date.
TABLES:
student: autonumber, first, last, grade
lunch: studentid, date, order(y/n field)

Of course, I have the tables put together. That took all of 10 minutes. Now I want to make a data entry/display form, and that is proving to be a challenge. I want to make a list of all the students, and then have 1 week at a time displayed like this:
and so on.

I was going to do it with a sub-form. That won't work because you can't have have continuous view set on a form with subforms. If I try and just have unbound check boxes and use VB to set the values, all checkboxes in that column take on the same value in continuous form view.

I've tried 3-4 permutations, and now feel a bit humbled because I thought I could bang this out in an hour. Does anyone have any suggestions on how I can make a form like this?

Thanks for any input,
Quint

I would create a temporary table containing the names and weekdays for each student then attach that to a sub form as a datasheet. Add a save button to the main form and if the user presses that write the data back to the master table. Doing it this way means that you can implement a Save/Cancel scenario. If the user hits the cancel button all you have to do is recreate the temporary table etc.

Hope this helps??
-Chris

If you are using Access 2002/3 I would try a pivotview of joined tables. It is a lot easier than it looks.

Cheers Ray

Unfortunately, I only have access 2000 at this point, so the Pivot Table isn't an option. But I think the temp table is the way to go. I was trying to avoid doing that for such a small project, but I like the ability to do the Save/Cancel step from a UI perspective.

Thanks for the ideas,
Quint