Before I get started, some basic terminology I'll use:
Assessor and User are not the same person. The user is inputting the information the assessor completed in the PDF/Word Document version of the CSE Assessment
So, a bit of background to my database:
I'm trying to collect the responses to many CSE Assessment forms in an Access database (example of said form is attached)
Problem 1:
The user is now able to add assessments to the database, but I'm not sure how to go about viewing (and then editing) these forms if there was an error during the input stage.
Part a (probably two separate issues):
I'm currently experiencing some problems opening the AssessmentRecord form (To get here, search for an ID in the Liberi ID text box on the Homepage (automatically opened)). If I search for ID 70, the Child's record displays fine, however when I then click the "View Assessments" button, the below error box appears, the ID changes to 71 and the subform is already populated with an assessor's name - despite the fact no assessors were selected from the dropdown.
Part b:
Ideally - once on the "AssessmentRecord" form - I'd like to go to the child's record, and select the View Assessments button. As some children could have many assessments, the user may wish to narrow it down by selecting a specific assessor, or they may wish to view all assessments, no matter who the assessor was. Ideally, this would be achieved by selecting the "View Assessments" button on the "ChildRecord" form.
Problem 2:
Also, if the user attempted to create a duplicate record for the child (Homepage, Add Child button) instead of just coming up with an error (example shown below, debugging section highlighted also shown), I'd like a message box to appear with two options - 1) Effectively cancel so they can correct the child ID, 2) take the user to the child's record with the ID they entered. this is because I believe there are two reasons a record may be entered twice - 1) mistyping when entering the ID 2) they did not check if the child was already in the database before attempting to add them, this would allow them to check the children are the same and there was not an error previously.
If you have any solutions to any of my problems, I'm all ears
I have attached the database for your use, if you have any questions, I'm happy to assist in any way I can.