ACCESS FEED: [MS_AccessPros] Loading Combo Box

Rabu, 18 Mei 2011

[MS_AccessPros] Loading Combo Box

Need help loading a combo box on the on open event. We need the combo box to show the values returned in the SELECT statement when the form opens. The combo box has 2 columns and 1 is bound. Column widths are set to 0";1". Here is the SELECT statement that is working correctly.

Me.CMB_PLATFORM.RowSource = "SELECT LOOKUP_VALUE, LOOKUP_DESC FROM LSDMGR_MOD_LOSS_MIT_LOOKUP " & _
"WHERE (((LOOKUP_TYPE)='PLATFORM_LEVEL') " & _
"AND ((LOOKUP_VALUE) = 4));"

The SELECT is pulling the correct data in the two fields, it's just not displaying in the combo box when the form opens.

Thanks in advance!
Mike

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity: