need help

[aikiju]

I have a table that has a PK, studentID, courceID, inscriptionDate, belt color.

I would like to make a form where I chose a student from drop down list, then the program locates that place in the table and allow me to enter cource, inscription date and belt color. I have done the design, but I cannot get the form go to the right record when I choose the student.
The student name I choose from another table table then query it so that i would see the names, instead of numbers and the same thing is for cources.

Here is the screen shot.

 

[Mr.K]

Did you try creating the combo box students with the wizard? The wizard gives you an option to: Find a record on my form base on the value I selected in my combo box; if you use that then when you select a record from the combobox the form will go to the specified student. This may not be a solution but the "GoTo" box created by the wizard might give you some ideas.

 

[aikiju]

the problem is that the records table contains only numbers that associate with every student, and if I use the combo box wizard ,then i would just have a list of <<PK>> that I would be selecting. But what I have right now, is a query so that I could see student names, and I cannot get it to work the same way.

 

[Mr.K]

doesn't your query have a StudentID as well? If so create the combobox (with wizard as I wrote above) but based on the query not the table. Then when it asks you to add fields add all three: ID, fname, lname and then click next. then it will ask you if you wish to hide the id field - say yes and your combo should only show student name but have the ID as the value and then you can see if it selects the record.
It may not work but in any case your combo should store the ID even though you'll be able only to see the names. Then you can try to use some Select commands in vba on afterupdate event, if the solution with the wizard doesn't work.

 

[aikiju]

I did similarly to the way you mentionned but a little bit different, since I was trying to find a value and not store a value, and only store it if it does not exist in the table. well anyways I got it to work. thx.