The tables are linked by tblStudentData.ClassID to tblClassDetails.ClassID and
tblStudentData.StudentID to tblResultsData.StudentID.
I want to create a form that has a combobox that has a list of the classes (Class71, Class 72). On the same form is a table. Selecting the class in the combobox automatically updates the form with students only in this class.
The table on the form needs to have 7 columns:
The Third most recent result
The second most recent result
The First most recent result
A blank column for the teacher to enter a new result.
It should look like this:
FirstName,Surname,Target,Third,Second,First,New Bob,Thurman,C,,Level 5, Level 4
Phill, Everitt,D,Level 5, Level 4, Level 6
And so on for the other 28 students
The first three are easy, as is the most recent result using 'max'. However, I cannot get the second and third results, and not sure how to get them into the same table.
Also not sure how to get Access to give me a blank column for adding data into.
I then need a command button that when pressed writes the data that the teacher has entered in the blank column into the results table.
Any help would be gratefully received! I am a novice in Access and SQL (I know the basics) but am fairly good with Excel and VBA.
If your tables are linked correctly and you have linked your form correctly, then creating a combobox will fill in the form as it is only a filter.Have you created the form yet? Tried creating a combo? Post the results!