|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 29th, 2007, 05:47 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Linking Parent Form to a Child Form
" wrote in
oups.com: 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. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com 
|
|
#2
September 29th, 2007, 06:01 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Linking Parent Form to a Child Form
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.
|
|
#3
September 29th, 2007, 06:53 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Linking Parent Form to a Child Form
On Sep 29, 12:47 pm, Bob Quintal wrote:
" wrote groups.com: 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. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account fromhttp://www.teranews.com I forget how to get to the wizard?
|
|
#4
September 29th, 2007, 06:55 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Linking Parent Form to a Child Form
On Sep 29, 12:47 pm, Bob Quintal wrote:
" wrote groups.com: 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. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account fromhttp://www.teranews.com Would that be the command button with the wizard highlighted?
|
|
#5
September 29th, 2007, 07:01 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Linking Parent Form to a Child Form
On Sep 29, 1:55 pm, "
wrote: On Sep 29, 12:47 pm, Bob Quintal wrote: " wrote groups.com: 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. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account fromhttp://www.teranews.com 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.
|
|
#6
September 29th, 2007, 07:37 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Linking Parent Form to a Child Form
" wrote in
ups.com: On Sep 29, 1:55 pm, " wrote: On Sep 29, 12:47 pm, Bob Quintal wrote: " wrote groups.com: 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. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account fromhttp://www.teranews.com 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. What does it go to? -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com
|
|
#7
September 29th, 2007, 08:38 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Linking Parent Form to a Child Form
On Sep 29, 2:37 pm, Bob Quintal wrote:
" wrote roups.com: On Sep 29, 1:55 pm, " wrote: On Sep 29, 12:47 pm, Bob Quintal wrote: " wrote groups.com: 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. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account fromhttp://www.teranews.com 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. What does it go to? -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account fromhttp://www.teranews.com- Hide quoted text - - Show quoted text - it goes to the first record in the child information form.
|
|
#8
September 29th, 2007, 08:41 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Linking Parent Form to a Child Form
|
|
#9
September 29th, 2007, 11:54 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Linking Parent Form to a Child Form
" wrote in
ups.com: On Sep 29, 2:37 pm, Bob Quintal wrote: " wrote roups.com: On Sep 29, 1:55 pm, " wrote: On Sep 29, 12:47 pm, Bob Quintal wrote: " wrote innews:1191085309.369780.189680 @d55g2000hsg.googlegroups.com: 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. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account fromhttp://www.teranews.com 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. What does it go to? -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account fromhttp://www.teranews.com- Hide quoted text - - Show quoted text - 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. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
