How I resolved this problem was to run multiple forms, and
match the forms based off set criteria. In your case it
would probably be like this:
Create a form with a text box and a button.
Under "on Click" in button properties, enter code to open
form 1 based off a match between the text box and the
field "Name" on Form 1. Add the same code, but change the
match from Form 1 to Form 2, and end the sub.
As you get more complex relationships, you can use And and
Or expressions to further limit the matched records that
display.
Hope that helps.
Edm
-----Original Message-----
I need help to create a form on which to search for a
name and a subform to load all their details (which allows
me to add/edit info.). Is this possible? How???
