Linking Parent Form to a Child Form

[Bob Quintal]

I have two forms. One is Parent Information and One is Child
Information. When I am editing an existing record in a Parent
Information, I would like a button to take me directly to the
parent's child in the Child Informaion. Also, when in Parent
Information, when I enter a new record, I would like a button to
take me to the Child Information to add a new record. Is this
possible. Your help is much appreciated. Thank you.

Add the button using the Wizard.The wizard asks what you want to do:
->Form Operations-> "Open Form" ->next "Open the form and find specific
data to display"->Next->"Select the fields and then click the <->
button"->type the text you want on the button and click ok.

If there are no children for this parent, the form will open on a new
record so you can add some.

You may need to save the parent record before clicking on the button,
if the parent record is a new one.

 

[debbiep]

I have two forms. One is Parent Information and One is Child
Information. When I am editing an existing record in a Parent
Information, I would like a button to take me directly to the parent's
child in the Child Informaion. Also, when in Parent Information, when
I enter a new record, I would like a button to take me to the Child
Information to add a new record. Is this possible. Your help is much
appreciated. Thank you.

 

[debbiep]

Add the button using the Wizard.The wizard asks what you want to do:
->Form Operations-> "Open Form" ->next "Open the form and find specific
data to display"->Next->"Select the fields and then click the <->
button"->type the text you want on the button and click ok.

If there are no children for this parent, the form will open on a new
record so you can add some.

You may need to save the parent record before clicking on the button,
if the parent record is a new one.

I forget how to get to the wizard?

 

[debbiep]

Add the button using the Wizard.The wizard asks what you want to do:
->Form Operations-> "Open Form" ->next "Open the form and find specific
data to display"->Next->"Select the fields and then click the <->
button"->type the text you want on the button and click ok.

If there are no children for this parent, the form will open on a new
record so you can add some.

You may need to save the parent record before clicking on the button,
if the parent record is a new one.

Would that be the command button with the wizard highlighted?

 

[debbiep]

Would that be the command button with the wizard highlighted?- Hide quoted text -

- Show quoted text -

ok, i got that, however, it never goes to the child of the parent. My
relationships are Child Acct to Child Acct.

 

[Bob Quintal]

ok, i got that, however, it never goes to the child of the parent.
My relationships are Child Acct to Child Acct.

What does it go to?

 

[debbiep]

What does it go to?

it goes to the first record in the child information form.

 

[Rick Brandt]

it goes to the first record in the child information form.

Post the code behind your button.

 

[Bob Quintal]

it goes to the first record in the child information form.

The Access Wizard, like the Wizard of Oz couldn't get Dorothy home.

So click your heels together 3 times, post the code that the Wizard
did create and we'll fix it.

To get the code, open the form in design view, click once on the
button, select the OnClick Property and click on the little button
with 3 dots (an ellipse) and the code editor will open to the event.