Create a dropdown list from each row with multiple columns from a query.

[GEG]

I'm new to this and it may be a simple question, but I can't find it and I have been trying to figure out how to create dropdown list from column heads. I made a query that takes the model # and several column with shaft sizes that apply to all model #'s. A table that lists all the model #'s and a yes field for all that that fir the model #. the query list them as I'd like, but I cannot figure out hao to make them into a drop down list so I can just click on the appropriate shaft.

[Gicu]

I think you'll need to provide a bit more specific info on where this desired dropdown is to be used; in a combo box control (which is what is usually referred to as a "dropdown") you can set the RowSourceType property to Field List and Row source to the name of your table or query and it will populate the combo with the field (column) names.

Cheers,

[GEG]

That did it, I knew it was probably something simple. I just couldn't find anything telling me that.