Updating Record with form help

I am VERY new to Access, and my guess is this question is fairly easy.



Here are my tables

Question Table

ID

Question

AnswerID

CategoryID



Answer Table

ID

Answer



Category Table

ID

Category





So my form shows :

Question, Answer, Category



And I can display any existing question and make updates to the question and answer, that works fine. BUT, what I want to do is update which category a question is in. If I change the Category in the form, it updates the 'Category' in the Category table. What I want it to do is update the CategoryID in the question table.

Updating Record with form help