The following piece of code....
DoCmd.GoToRecord , , acFirst
Debug.Print "Student Code " & [Student Code]
... as you can see intructs Access to go to the first record, which is student code '1'. As I step through the code, I actually see the record appear in the background but the above Debug.Print statement returns '0' and al the other fields are obviously null.
Do I need to load the record programmatically? How do I do it?