Data Lookup

  • Thread starter Thread starter Sash
  • Start date Start date
S

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!
 
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.
 
Back
Top