Grouping Data on an input form

[Chuck W]

Hi,
I have a table that has the following fields:

Month Weight UVC UAC CVL
1/1/09 <750 0 1 0
1/1/09 751-1000 1 2 1
1/1/09 >1000 0 3 1
2/1/09 <750 1 1 1
2/1/09 751-1000 1 2 2
2/1/09 >1000 2 0 1

So for every month, there is three weight categories that repeat and the
user needs to input an integer for the UVC, UAC or CVL categories. I want to
create an input form where a user plugs in this data. I want each month to
appear on a form at one time and then use the navigation buttons to toggle
between months. I can't figure out how to set the form up to do this. How
can I get the first three records at a time to appear on the form page and
then use the navigation button to move to the next three?

Also, I plan to just add about 12 months of future data with the weight
categoires as well so that the user doesn't need to plug these in. Is there
a better way to do this? These categories never change.

Thanks,

 

[Chegu Tom]

It sounds like you need a main form and a sub form

The main form should be based on a grouped query by month (One record per
month)

The subform should be based on your table and linked to the main form by
month

So as you page through the months on the main form the details for each
month will show on the subform (in datasheet or continuous forms view)

Tom