Obviously, I'm not great with Access. I think this should be somewhat simple, yet can't figure it out. I have a table with several records in it. I want to create "form" (maybe??) to make it easier for my secretary to update student information. On the header of the form I'd like to have the student's firstname, lastname, & gradelevel fields pulled and automatically filled in from the records in the table. In the details of the form, I would like my secretary to simply enter completion dates and grades for certain tasks (other fields in the aforementioned) table which would in turn update the fields in the table.
Am I making sense, or am I way off?
Thanks for any help!