I have a recordset, rstStudentData, in which I want to see the contents of a particular field. The particular field is in column 1 of the item that is selected in a list box, lstAreaTopic. What is the syntax for doing that?
I have tried the following code:
strFieldText = rstStudentData![lstAreaTopic.Column(1)]
strFieldText = rstStudentData!Me![lstAreaTopic.Column(1)]
where strFieldText will be the text that is in the selected field. No matter what I try, I always get the error message "Run-time error 3265: Item not found in this collection".
I want to pass a parameter because I have many fields (about 75) and don't want to get into hard coding all of that!