combo box probs...

[Howlsta]

I've made a form for adding new students and their information. The problem is some columns in my students table are ID fields (eg courseID). I want the user to be able to select the name of the course (in tblcourse) from a combo box on the form, rather than having to know the courseID. I built a qry including the course name field and it works ok as a text field, but if I change it to a combo box by changing row source and stuff, it keeps cocking up (eg if i try to change an existing students course it changes the name of the course in tblCourse, instead of changing the courseID in tblStudent).

I think this should be easy to do but for some reason i keep getting it wrong.

Can anyone help pls?

 

[AlanS]

Try using the combo box wizard to construct the combo box, then inspect its properties to see how it's done. If it's updating the wrong table, that's probably because you have it bound to the wrong table.

 

[Howlsta]

Cheers ive got it now, stupid mistake got the control source wrong!