I had a similar problem. But I used wizard to solve it.
Make a form using wizard.
Once you complete the form. Click on form and choose design
Add combo and choose the option 3 which says find the record..
Post that select the field which you want to add to combo.
Make sure that you add combo in the header part of form
I think this should work
<a href=”http://findsarfaraz.blogspot.com”>MS Excel help</a>