How to select ComboBox list in Run time

[sdondeti]

Hi,



In Run time Combo Box list is filled with sql as below:

Select State, acctID, BranchID, BranchName, DivisionID,
Inactive, sqlBranchID from vqryBranch

User can select combobox one of the populated list from the above query.

I got a requirement to programatically select one of the list in combo box.

I did program as :
Forms![frminitialclaims]![Branch ID] = varBranchID

Its not getting selected but if i check the field in immediate window i can see the data what i expected which is not showing in combo box.
Can some one help me how to populate the value through programatically.

Thank you all.

SDondeti

[pkstormy]

I would do a msgbox to make sure varBranchID is a valid integer that would be in the listing of the combobox rowsource and make sure that the combobox has the right column as the bound column.

ex:
msgbox varBranchID
Forms![frminitialclaims]![Branch ID] = varBranchID
msgbox Forms![frminitialclaims]![Branch ID]

Otherwise the code looks to be correct to do what you want to do.

[sdondeti]

I checked it. That gives me exactly what i required but it does not show or select from the combobox list.

from Immediate window i got the result as:
?Forms![frminitialclaims]![Branch ID]
EAST

but ComboBox appear as null. what should i do to see this value ? is there any properties to be changed. Its in enable and visible. but no value appeared.

Thank you.