Record Sources...still

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a way to 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]

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 ....
 
If your table has the 4 fields indicated, then it should be the appropriate
recordsource for your form.

What problem are you encountering using it as the recordsource?

The CollectionTable.Group.[Budget] and CollectionTable.Group.[Actual] syntax
is definitely incorrect. Where do you want to use it?
 
Because the table and form are formatted differently, I can't match them up.
For instance,
Budget Actual
Group 1 _entry a ______

for "entry a" there isn't a directly corresponding field in the table:

Collection Group Budget Actual
Col 1 Grp 1 10 20

without somehow specifying the collection and group first. Any ideas on how
to do this? Thanks

Doug Steele said:
If your table has the 4 fields indicated, then it should be the appropriate
recordsource for your form.

What problem are you encountering using it as the recordsource?

The CollectionTable.Group.[Budget] and CollectionTable.Group.[Actual] syntax
is definitely incorrect. Where do you want to use it?

--
Doug Steele, Microsoft Access MVP



awach said:
I am looking for a way to 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]

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 ....
Click to expand...
Click to expand...
 
Back
Top