Dropdown combo box problem

[mcbass1]

New Access user here, so be kind:

I've created a form that includes a dropdown combo box for Name and a text box for Employee Number, with the control source being a query. In a subform from another query, I have other fields that are linked to the employee# field of the form. The form is working perfectly except for one thing. After I click on a name, which populates all of the fields, if I scroll with the mousewheel, all the records scroll with the exception of the name in the dropdown.

I've fixed this by moving the focus to the subform after updating the dropdown, but I think I'd rather have the combo box scroll with the related populated fields. If I put a control source in for the dropdown box, it will scroll like I want but won't allow me to chose a name from the drop down. All it will let me do is scroll. It's like I can do one or the other but not both.

Thanks for your help,
Mike

 

[ajetrumpet]

Bass,

I believe if you enter a control source and a row source for a control, it will use the control source first. I don't think you can change one to the other, even with code. But if you could, it just seems like too many tasks for one form (to me anyway); seems like I just said this yesterday....

 

[Uncle Gizmo]

I would guess it's because the combo box is unbound, is this the case?