Manipulating Datacombo

[guillermococa]

Excuse me
Hello, I have a problem with a combo.
Previously it had created an application with access, and to pass the application with VB6, I have trouble managing combos.
I need to know if you use a combo or a datacombo.
About this control, they carry data via a query sql charged in a recordset, which returns 2 fields, codes and descriptions.
For handling the application is necessary that the list descriptions are loaded, but when holding the focus, this switch to codes to the user can enter them manually, and will leave again be descriptions of the codes.
Nor encounter as limiting values that are placed manually to be those on the list.

 

[BobRodes]

Use a combo, not a data combo. First, use AddItem to populate the combo with the contents of a recordset.

I don't quite get the meaning of "Nor encounter as limiting values that are placed manually to be those on the list." Do you want to be able to add values manually and have them be added to the list, or not?

 

[guillermococa]

Thanks (excuse me for my english), but I need load more than 3 combos and the method additem is more slow. I need load with SQL because the sql request is dinamic and can be change.

About this control, returns 2 fields, codes and description.
For handling the application is necessary that the list descriptions are loaded, but when holding the focus, this switch to codes to the user can enter them manually, and will leave again be descriptions of the codes.

If you can give me your e-mail, I send a example

 

[BobRodes]

<excuse me for my english
I'm sure it's a lot better than my command of your language.

<the method additem is more slow
I never found it to be unacceptably slow.

<sql request is dinamic and can be change.
The method I explained uses SQL.

<If you can give me your e-mail
I'm sorry, we don't do that here. Perhaps you will post your example right here so we can all look at it. Try to remove parts of the code that are not relevant to the current discussion.