Combo Box Bound

[jandrade15]

I want to put a combo box in a form but having some issues....

I want to get only 5 of the 20 fields in my Access DB. I only want the Columns or fields not the values... I have my form bound with ADO....
Can anyone tell me the simplest way to do this ??? Ive been trying for about 2hrs and no luck!!!! Thanks for all your help in advanced!

[Ecniv]

You could hard code values and manually fill (in vb/vba - in access on the combo properties you can list values).

You could have a table with all the fields you want the user to search on/see then point your combo to this filtering on tablename

Example:
ID - Auto
STbl - Text <use this to show depending on query/table/form using
SFld - Text

You could code a loop in vba to pull back all the fields, but you'd still need a list somewhere for the viewable fields.