Create form with xy data entry

[bfunkyf]

I have a table with 160 fields of academic disciplines (20) by degree type
(8) for each institution. I want to create a form that will show a 20x8 grid
into which the users will enter numbers of degrees awarded in each discipline
by type of degree and have that data stored in the table under the correct
institution. How do I do that, or where can I find a sample of a form that
has an imbedded xy grid in a form?

 

[Arvin Meyer MVP]

Use a spreadsheet. That's what you have designed.

For a database, your design is non-relational and needs to change. What
would happen of you had a different degree type? or added 5 more
institutions?

 

[bfunkyf]

Yes, it is a spreadsheet, and I was trying to figure out how to imbed or
create such a simple spreadsheet in an Access form, in a way that would
result in the data being entered in the form populating the correct fields in
the correct table.
Actually, I figured it out by playing around. I brought all 160 fields into
the form and arranged them into a 8 by 20 grid. I deleted all the imbedded
labels and then placed 8 new labels (Carnegie classifications) across the top
of my grid, and 20 labels down the left side for the disciplines (I had to
"Ignore Error" for each of these labels).
Now when a user uses the form, they enter their numbers into whichever spot
in the grid/speadsheet they have data for (usually only between 1 and 40),
and it populates the table correctly.