I have a table with Program names in it, and a subform that contains notes about the program.
If it were working perfectly, the report would look like this:
Program 1
-Date
-Notes
-Date
-Notes
(where all notes are under the program 1 entry)
Instead, I get a complete new record when a new note is added on the subform, so the report looks like this:
Program 1
-Date
-Notes
Program 1
-Date
-Notes
I cant figure out how to fix it. The user of the db will have upwards of 40 programs and currently, the subforms are forcing close to 400 pages of printing as opposed to the 40 it should take.
I can provide the database with test data if someone would like to take a look at it. I dont know what else to do with it and I am still in the novice stage of everything.
Hopefully I explained this fairly well.
Thank you.
If it were working perfectly, the report would look like this:
Program 1
-Date
-Notes
-Date
-Notes
(where all notes are under the program 1 entry)
Instead, I get a complete new record when a new note is added on the subform, so the report looks like this:
Program 1
-Date
-Notes
Program 1
-Date
-Notes
I cant figure out how to fix it. The user of the db will have upwards of 40 programs and currently, the subforms are forcing close to 400 pages of printing as opposed to the 40 it should take.
I can provide the database with test data if someone would like to take a look at it. I dont know what else to do with it and I am still in the novice stage of everything.
Hopefully I explained this fairly well.
Thank you.
