combo box retrieving

[Former Member]

hi friends

i have a combo box in my form and i want to retrieve data from the system database(eg"OCRD").what do i have to do . i want your assisstant

thanks and regards

Manoj Nagaraj

[Former Member · Accepted solution]

Hello Manoj

I'm guessing that you are retrieving CardCode from OCRD nad filling it in your combobox as you have not mentioned more details.

If so ,you would have a query to that table OCRD like

rs.DoQuery("SELECT CARDCODE,CARDNAME FROM [OCRD]")

Based on this query you add validvalues to your combobox as

For i as integer=1 to rs.recordcount
ocmb.Validvalues.Add(rs.Fields.Item(0).Value,rs.Fields.Item(1).Value)
rs.Movenext
Next

HTH

Raghu

[Former Member · Accepted solution]

hi raghu

there is a combo box in the system form for select the gender(Male or Female).i have to retrive that value to my form's combo box(same gender).what do i have to do?am i clear in my question?

thanks and regards

Manoj Nagaraj

[Former Member · Accepted solution]

hi Manoj

if this means that you want to select on your combo box the same value that is selected on another combo box (in the case that this value is not stored into the database) than you should get a reference of that system form, get a reference of the combo box, and get the selected value, than you should call select on your combo box using the value you got using psk_Value as search key.

Otherwise if the info about gender is stored on the database than i suggest to use the business object of that system form to retrieve data