I have question about combo box. In the table, i have ID and Name. When i use Combo44.value it will retrieve the ID. How can i retrieve the name. Use combo44.text??? I am not sure.
The following is the code:
Private Sub Combo44_AfterUpdate()
Dim SQL As String
SQL = "SELECT Categories FROM tblFundCategories WHERE Fund = "
If Not IsNull(Me.Combo44.Text) Then
SQL = SQL & Me.Combo44.Text