Hi, i have a split form with a tab and listbox and i set the on current event on the form as the following, so the tab will be hidden and the rowSource will be updated whenever user selects a new record.
however, nothing worked, but MsgBox.
anyone?
thank you for your help.
Private Sub Form_Current()
linkTabs.Visible = False
MsgBox "JJK"
Me.cbo_vpl.RowSource = "SELECT p.platform_id_cd, p.platform_title_tx " + _
"FROM variant_platform_link vpl, radio_variant rv, platform p " + _
"where vpl.[Radio Variant] = rv.radio_variant_id_cd " + _
"and vpl.[Platform] = p.platform_id_cd " + _
"and rv.radio_variant_id_cd = " + Str(radio_variant_id_cd)
MsgBox "JJK2"
End Sub