Combining Family members with their sponsor

[Whispersplus1]

I have successfully created a form with a sub-form that opens up the information I'm requesting based on the parameters set in the querry for the form. My problem is that when the results appear each person has been placed on their own form. For me this means scolling through forms until the family member I'm looking for appears. I want to be able to utilize the parameter, which by the way is their assigned box toopenone form with a choice of family member (combo box/list) and when I choose, the sub-form reacts accordingly. After I've enter the data I wish to enter, a control button should reopen the form and its parameter for the next piece. I've seen older databases working similar to the way i've described. Only, they use look-up tables, which I'm trying to avoid. I have attached a small database that almost does what I want. The functionality is not as smooth as I wish.
Can someone please help.

 

[wiklendt]

i can't figure out what you're doing (and what the problem is?), either from your description or even by looking at your database. you could get a smoother form by making it more obvious to the form user what they're supposed to do and not have random, unexpected events happen when they hit a key (i found it very frustrating).

also, many people on the forum still use pre-2007 access program, so there are many experts you are turning away by posting a 2007 database file. convert it to 2003 and you'll probably find more people willing to tackle your problem.

now, for some suggestions:

you could, for example, have a listbox with all the "box #"s listed, and when one is selected it will update the combo, and once the combo is selected, it updates the subform. no weird key presses, no weird and strange (unknown) numbers to add to popup boxes.

here's an example of what i mean, in a different context...

in the listbox on the left is where you can have your Box#, then once that is chosen you could have another listbox, or just a combo box with the names associated with that listbox. you can also have various filters on the form to make your search easier, e.g., if you know the box # has a "13" in it, you can type "13" in the text search field and it will narrow the list down for you.

you can then have one or more subforms associated with the parent form.