My first ever post, I've set aside my inhibitions to actually ask a dumb Question.
I have two tables one has a student roll number and name and the other has the subjects he took, the marks he got when he did that.. etc

the data is not clean and for that.. i need to build a form where i have a text box with one student id, a list box with all his courses/marks/dates he took them. And when i click on a single record .. it should display that very record for editing!



This is where i am at.. i have the student list.. i am not being able to limit the list box to display just a single students stuff.. it shows all whats there in the whole table.

And when i click on the single record.. it doesn't let me choose from the many records one student has. it keeps on the first one! also.. i have been using DoCmd.OpenForm which opens a form.. but somebody dumb doesn't want that.. they want it in the same form...

I'd appreciate your help..... and there'll be more to come ya see i've never worked with Access before and this data is messy!