I have a regular combo box that I need to be editable (style=0) and I wanted to just pre-populate the combo with the current values in the database. For example, say I have a 'CITY' combo box and a 'RESIDES IN CITY' field in my database. I want to populate the combo box with the values from all the records in the RESIDES IN CITY' field of the database so that the user may select one that already exists rather than typing one in. If they type one in that is not there, I will handle that in code rather than a binding issue. Thanks!
NOTE: I am dealing with a connection object, not global recordsets:
Set cboCity.DataSource = oDataConnection.Execute("SELECT [RESIDES IN CITY] FROM [Data];", , adCmdText)
cboCity.DataField = "RESIDES IN CITY"