Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Append data to one field in subform

Status
Not open for further replies.

dtecta

Technical User
Joined
Feb 3, 2003
Messages
7
Location
US
I am working with a subform that tracks student scores for each item in a developmental inventory. Because I wanted to attach information to each item (age level), I set up the tables like this:

Items:
ItemID (e.g. DFM-01, DFM-02, etc.)
Item
DevAge

Scores:
AssessmentID
ItemID
Score

Assessments:
AssemmentID (autonum)
ChildID
ExaminerID
TestDate
Comments

Now I have created a form with a scores subform, and I would like all of the ItemIDs from the Items table to appear in that subform. I have tried to use an Append Query... this results in the ItemIDs being appended to the Scores Table with the AssessmentID (autonum) being set to 0, but not to the subform itself, which is where the data entry is being done. In effect, rather than choosing each ItemID from a pull-down menu, I would like the subform to automatically display all ItemIDs and then the data entry person would only need to update the scores for each student.

Any and all suggestions would be greatly appreciated! I hope I have been clear enough in my description.

Deidre
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top