Using a Query to use as source for data entry

[doucecool57]

Here goes, I have a table with information about the current goals for students: Student ID, Goal, Objective, Focus, StartDate, EndDate, Goal Met (Yes/No).



My goal is to pull this information into a form where the end user is presented with the current goals of one student/all students and is able to check Yes/No, if they met that goal...they would then submit that form which updates another table where goal progress is tracked.

Steps I've tried but can't quite nail down:

1. Select Query to display current goals of students in the Goal Progress Entry sub-Form
2. Insert Query to insert that data into the separate "Goal Progress Table"

Part I'm having trouble with is that I almost need the source of the first query to be ended so that I am not updating my Student Goal Table when doing data entry...would need it static at that point.

Thoughts on the best way to accomplish this? Let me know if anything needs to be clarified.

[orange]

Seems you have/could have multiple entities and require multiple tables.
Can a student have more than 1 goal or more than 1 objective?
Can multiple students have the same goal/objective?
Perhaps you could describe goals and objectives for a few fictitious students so readers have a clear picture of your project.

[doucecool57]

Sorry, should have explained in more detail:

Yes, a student can have more than one goal/Objective and can be shared....

Focus/Goal/Benchmark are not data points that could be put in separate tables as they change often and are more narrative.