Hi.Friends
database file is hereby attached for easy reference. plz guide me
Im new and having a basic level knowledge of VB. I am facing a problem to make a dashboard. I used a command button. "After click" event following coding were used
Private Sub Command2_Click()
Me.FormValue.Value = 1
Me.cbosource.RowSource = "SELECT[source].[formname] FROM" & _
" Source WHERE Formvalue = " & Me.FormValue & _
" Order By formvalue"
after click event my combobox shows correct value. i used following after click event code on combobox
Private Sub cbosource_AfterUpdate()
If Me.cbosource.Value = "" Then
End
Else
Me.Child6.SourceObject = Me.cbosource
End If
End Sub
where child6 is a subform on my dashboard.
but after click combo box event is not populating my subform.
database file is hereby attached. plz guide me
database file is hereby attached for easy reference. plz guide me
Im new and having a basic level knowledge of VB. I am facing a problem to make a dashboard. I used a command button. "After click" event following coding were used
Private Sub Command2_Click()
Me.FormValue.Value = 1
Me.cbosource.RowSource = "SELECT[source].[formname] FROM" & _
" Source WHERE Formvalue = " & Me.FormValue & _
" Order By formvalue"
after click event my combobox shows correct value. i used following after click event code on combobox
Private Sub cbosource_AfterUpdate()
If Me.cbosource.Value = "" Then
End
Else
Me.Child6.SourceObject = Me.cbosource
End If
End Sub
where child6 is a subform on my dashboard.
but after click combo box event is not populating my subform.
database file is hereby attached. plz guide me