Form with combo box, where chosen value causes the rest of the form to populate

[mles]

I have a table that contains these fields: ID, JobNumber, Title, Date. I want to make a combo box for JobNumber so that I can choose a value for JobNumber, and have the other fields on the form autopopulate with information from the table. I'm sure this is really obvious and I'm just missing it.

 

[mles]

SELECT DISTINCTROW tbl_OffsiteCDs.CDID, tbl_OffsiteCDs.JobNumber
FROM tbl_OffsiteCDs
ORDER BY tbl_OffsiteCDs.JobNumber;

is the code I'm using for the query from the combo box JobNumber. But choosing a JobNumber in the combo box is NOT updating the other fields on the form. What's wrong?