Heya guys. Might be a simple question, but for the life of me I couldn't hit the right search string in google and find what I'm looking for, so I guess I'll bother all of you instead :p
Alright, the thing is I'd like to create a combo box who's got a table as a source for its Field List. So far so good - the drop-down options are showing up as "fldName", "fldAddress", etc, cuz I'm a good little boy and set my db up with a naming convention and everything.
However, I'd rather the options showed up as their captions, so instead of a list full of "fldXXXX"'s, I'd have something like "Name", "Address" etc, which are the field Captions in the table itself.
Is this doable either using VBA or a SELECT statement in the combo box's "Row Source" field? If the former, be aware I'm a total retard when it comes to coding so please be gentle...
Thanks in advance!