Prev: HELP: Error! No document variable supplied
Next: record in datasheet
From: Pete Coales on 29 Oct 2009 20:15
I have a subform that contains a treeview that is populated with tasks and
their followups etc...

I want this subform to be placed on a number of parent forms which will
invoke a sub on the subform to populate the treeview using a filter based on
the value of the main forms entity... ie when on the customers form only show
tasks for that customer etc...

Problem is when I have one form open (eg the customers form) when I open the
second form (eg the projects form) the project tasks subforms treeview is not
populated

I have stepped thru the code and the correct query is run and the code adds
the correct items to the treeview but the treeview remains empty on screen

When I have one form open, either the customer or the project form, the task
subform it contains works perfectly. The problem only occurs when there is
more than one instance of the tasks subform open...

In the tasks subform I am referencing the treeview like this :

Dim tv As TreeView
Set tv = Me("tvTaskHistory").Object

rather than the usual Me.tvTaskHistory but neither method solves my problem.
From: Pete Coales on 29 Oct 2009 20:44
Thought best to point out this is Access 2007 running on Windows 7

"Pete Coales" wrote:

> I have a subform that contains a treeview that is populated with tasks and
> their followups etc...
>
> I want this subform to be placed on a number of parent forms which will
> invoke a sub on the subform to populate the treeview using a filter based on
> the value of the main forms entity... ie when on the customers form only show
> tasks for that customer etc...
>
> Problem is when I have one form open (eg the customers form) when I open the
> second form (eg the projects form) the project tasks subforms treeview is not
> populated
>
> I have stepped thru the code and the correct query is run and the code adds
> the correct items to the treeview but the treeview remains empty on screen
>
> When I have one form open, either the customer or the project form, the task
> subform it contains works perfectly. The problem only occurs when there is
> more than one instance of the tasks subform open...
>
> In the tasks subform I am referencing the treeview like this :
>
> Dim tv As TreeView
> Set tv = Me("tvTaskHistory").Object
>
> rather than the usual Me.tvTaskHistory but neither method solves my problem.
 | 
Pages: 1
Prev: HELP: Error! No document variable supplied
Next: record in datasheet