Help to popuplate a dashboard using combo (1 Viewer)

[aftab1965]

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

 

[arnelgp]

here is your dashboard.