Using a combobox to display results of query

[Dowsey1977]

I have a query which I am using as a subform on a form. However, I think a combobox would do a better job. Is there anyway to get a combobox to just disply these results?

 

[bat17]

yes, just use the query as the record source for the combobox.

Peter

 

[Dowsey1977]

Ok, so far so good! Was using control source and not row source!

I have managed to get it to work, but when you click on the drop down box you have to scrol across. As there are more than 1 'cells' for each record, but not a consistent number, I want any information to be displayed downwards, not across.

 

[bat17]

A combobox displays one record per row. if you have multiple columns you can alter their width from the property sheet to display them better.

HTH

Peter

 

[Dowsey1977]

Ok, change of plan! Using a form now, which is doing what I want. Is there anyway to only have a textbox show when there's something in it? (e.g. some fancy VB SCript or something!)