Combobox - Record Seletor

[ChrisAnthony]

Hi all,
I have DB that I want to use review candidates for a job position. I have one form “Form 8” that I want that hold the names of all the applicants and the job posting they applied for. I have sub form added to this form that displays the questions associated with the position. Inside of this sub I have another sub form that I use to record the answers related to each question for each applicant.
For some reason I can’t seem to select the applicant from the combobox only through the record select at the bottom of the form.
Can someone tell me how to select the applicant record from a drop down menu. I also have the same problem with the questions. I want to be able to select the record question from a drop down menu.
Thanks,
Chris

 

[Trevor G]

Your combo box on Form 8 has no row source to it so it wont display any records in the subform.

Open the form in design view, select your combo then go down until you get to row source, then use the elipses button to the right to take you into the query builder select the table tblApplicants then select the field.

Even though this is the issue you have more in the form as it states you cant save so you have some more work to do.

See attached

 

[ChrisAnthony]

Thanks Trev thats awesome ... i feel to foolish that I didn't figuer this out my self.

 

[boblarson]

Also, rename your forms and controls to something more meaningful than Form8. It will help the next person down the line or you after you haven't worked on it for 6 to 12 months and then you, or they, go back and are wondering what each thing does.