Identifying Record Sources

A

awach

I have a form that is setup like

Collection _________

Budget Actual
Group 1 _______ ______ blanks to enter info
Group 2 _______ ______
Group 3 _______ ______ .....

I want the information to be put in a table that is setup like

Collection Group Budget Actual
Col 1 Grp 1 10 20
Col 1 Grp 2 5 10
Col 1 Grp 3 3 8
Col 2 Grp 1 15 17 ....

How do I make the record source for the blanks in the form?

(I know this isn't right but something like CollectionTable.Group.[Budget]
and CollectionTable.Group.[Actual]
 
Top