retrieving a list of field captions for my combo box

[bonecone]

I want to populate a listbox with all the field captions of a particular table, not the field names. Can I do this with access?

[June7]

Probably with VBA code that reads caption property. Bet have to use TableDefs collection to get that property. Review this http://bytes.com/topic/access/answer...tables-caption

Then use AddItem method to add rows to listbox.

Use a loop structure.