G
Guest
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???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
EdwardA
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
me to add/edit info.). Is this possible? How???
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
name and a subform to load all their details (which allows-----Original Message-----
I need help to create a form on which to search for a
me to add/edit info.). Is this possible? How???