Data Lookup

[Sash]

I want to design a form where the user would key in a last name. This would
populate a list, for example:

Smith, John
Smith, Larry
Smith, Melissa
Smith, Sarah
Smith, Tom

Then the user would click on the name to display specific information on all
peopl with this name. For example, John Smith:

Smith, John
ACCT: 12345; DOB: 1/1/60
ACCT: 89739; DOB: 2/2/78
ACCT: 84050; DOB: 3/3/84

From here they could click the appropriate ACCT to get additonal data.

Currently, I have an input form where the user keys in the name and it opens
a continuous form where they can click a button to open another form, but
this seems very cumbersome and if the user needs to go back they have to
start from the begginning.

Hope this all makes sense. You are all so great about giving me some place
to start. I was trying to look at TreeViews, but am not sure this is my
answer and don't really understand about Nodes. Any suggestions would be
greatly appreciated!

 

[ryguy7272]

All you need to do is set up a Form and a SubForm. Look at this for the
details on how to get it set up:
http://www.jegsworks.com/Lessons/databases/formsreports/subformsubreport.htm

Look here for a visual sample of what it may look like when you are done:
http://www.databasedev.co.uk/subform-total.html

The 'Kasabian' is equivalent to your 'Smith'.

I can (virtually) guarantee that yours will look different, but you get the
idea...


HTH,
Ryan---

 

[Sash]

This was my initial thought, but you can't put a subform on a continuous form
and I would loose the list of names. The initial list of names could be
hundreds and it would be a lot easier for the user to deal with a list rather
than page through the names. I'll look at it again though...maybe I missed
something.