This has got me puzzled.
I have a combobox on the a parent form which has mdi children. The combo is used sort of like a filter. EG, 2000, 2001. The idea of it is to limit the records to only show the ones in the year selected.
When I change the year, I want all of the mdi children that are open to call a predetermined function on their own form to run through and select records for that year only.
I can run through each open window ok, but when it comes to calling the function, it tells me there is no object.
This is what I have so far. This function is on the main form where the combobox is.
Function SeasonPick(ByVal sea As String)
Dim win As Form
showseason = sea
For Each win In Me.MdiChildren
If win.Name = "FrmManageContacts" Then
win.Focus()
I want to be able to do the following.....its not right though.
win.TreePopulate(showseason)
End If
Next
The TreePopulate is the function on the FrmManageContacts form. I have made this function Public.
If anyone could help out, it would be great.
Steve
I have a combobox on the a parent form which has mdi children. The combo is used sort of like a filter. EG, 2000, 2001. The idea of it is to limit the records to only show the ones in the year selected.
When I change the year, I want all of the mdi children that are open to call a predetermined function on their own form to run through and select records for that year only.
I can run through each open window ok, but when it comes to calling the function, it tells me there is no object.
This is what I have so far. This function is on the main form where the combobox is.
Function SeasonPick(ByVal sea As String)
Dim win As Form
showseason = sea
For Each win In Me.MdiChildren
If win.Name = "FrmManageContacts" Then
win.Focus()
I want to be able to do the following.....its not right though.
win.TreePopulate(showseason)
End If
Next
The TreePopulate is the function on the FrmManageContacts form. I have made this function Public.
If anyone could help out, it would be great.
Steve