TreeView

[Sash]

I'm looking for suggestions. I have a project where I need the user to key
in a last name which I'm thinking would populate a treeview and display
everyone in the DB with that last name and DOB. The 2nd node of the DB would
have each persons visit to the doctor. For example:

Key in "Smith"

Smith, Jane -- 1/1/1990
Smith, Bob -- 2/2/1980
Smith, Jeff -- 3/3/1970

If I click the last one, I would see:

Smith, Jeff -- 3/3/1970
1/2/2008
4/5/2008
2/3/2009

And when I click on the date I get information regarding the visit.

I used Helen Feddema's example as a base and had the aforementioned working
until I added volumes of records. The issues included not being able to
scroll in the window so all the records didn't display; error message about
unique record (which I tried to fix using the ID field).

Sorry for being so long winded and I know without seeing my code you can't
specifically address my problem. But I'm basically looking to see if I
should continue down this path or take a different approach. I even wondered
if anyone new of and application that I could purchase that would accomplish
the aforementioned. I'm in panic mode because I have 2 weeks to get this
working.

 

[Tom van Stiphout]

On Tue, 28 Apr 2009 06:49:01 -0700, Sash

If you have only two levels, consider a subform with a sub-subform. It
displays similar to a treeview and when you expand a record the
subsubform appears. You could have a prototype running in just a few
hours, and you would be using familiar technology. Treeviews are best
for unknown or unlimited levels, and require a pretty thorough
understanding.

-Tom.
Microsoft Access MVP