College Student struggling with simple combo look ups arggh!

[neilswindonuk]

Hello people,

I'm not a programmer, I am infact a 17 year old College Student from the United Kingdom - Studying ICT!

For my major project I have to design, build and test a camera loans system for my photography department. Except, I am having problems with Combo box lookups. It's been over 6 months since I learnt this, and it's all a blank. Something as simple as this is simply not working...

e.g. in the Studentloans table, I wish to enter the Student ID number from the student ID card inside the combo box, and hit enter so that it brings up the relevant specific loans of that student.
I enter the id, hit enter and the student name, class etc does not change. Why? The same goes for my Camera Maintenance Table, Camera + Maintenance tables are combined to a CAMERAMAINTENANCE TABLE - Therefore I wish to enter the Camera ID number so that if i hit enter, it brings up the relevant service histories of that specific camera...

The relationships are all ok, the fields for Student ID are lookup, etc.

I don't understand. It's driving me insane. I need help with this, I'm struggling so much.

Help much appreciated.

Thanks - Neil.

 

[Laurentech]

You need to tell access to use the value that you entered in the combo box to go to the correct record.

The combo box used to enter the desired student id should be unbound. In the combo's afterupdate event put something like:

dim rst as object
set rst = me.recordset.clone
rst.findfirst "StudentID=Me.StudentIDCombo"
if not rst.eof then me.bookmark=rst.bookmark

This is off the top of my head, so it may need a little tweaking. Hope it at least gets you on the right track.

Larry