A field from table (ADO) display in a (simple) combobox

[ParkerWrecker]

i have here a form which supposedly will display the Password of a Computer on a label - as the user select a specific ComputerName from the Combobox by clicking a button,

how can i entirely get the records of the field(ComputerName), to display in a (Simple)Combobox (cmbComputerName).

as i have connect the ADO to the (simple)Combobox, the number of recs it can only display at a time is only one. How can i make the combobox display all of it at the same time.

table(DtaEntries)
fields(ComputerName, NPassword)
Combo1(cboComputerName)
Command1(cmdView)
label(lblPassword)

 

[johnwm]

If the ComboBox control is set to
[tt] Style = vbComboSimple[/tt]
and there is more than one item in the list, just increase the height.

Suggest you also review the answer I gave in thread222-719468 as you seem to have asked 9 questions and only acknowledged
a couple of the answers, and haven't yet marked any as valuable. If you're not getting the right answers, check out faq222-2244 to see how to do better research and ask better questions. If you are getting what you want the faq shows how to acknowledge them.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[ParkerWrecker]

i have already set that property.... but the thing is it only displays 1 rec, and it's in the textbox of the combobox.....

 

[johnwm]

Are you sure that you've got all the data in the Combo? Try changing the Style to Dropdown to make sure.

If it only contains one item then make sure that you've looped right through the recordset, using the AddItem method each time.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'