|
| 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
February 23rd, 2007, 04:05 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Opening a form from another one
I need the VBA code to open a form from another form and display the data
currently in a control of the first form in a control of the second form by clicking a button. I know about stLinkCriteria but some times mor flexibility is needed. I tried [Form2]![Control2]=Me![control1] after the "DoCmd.OpenForm.." in the "OnClick" property of the button but it did not work. Any idea? 
|
|
#2
February 23rd, 2007, 04:39 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Opening a form from another one
You could pass the data from your control in the OpenArgs parameter of the
OpenForm call, then pick up that value in the second form's Open or Load event and populate your control with it. Carl Rapson "Moe" wrote in message ... I need the VBA code to open a form from another form and display the data currently in a control of the first form in a control of the second form by clicking a button. I know about stLinkCriteria but some times mor flexibility is needed. I tried [Form2]![Control2]=Me![control1] after the "DoCmd.OpenForm.." in the "OnClick" property of the button but it did not work. Any idea?
|
|
#3
February 23rd, 2007, 04:44 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Opening a form from another one
You could pass the data from your control in the OpenArgs parameter of the
OpenForm call, then pick up that value in the second form's Open or Load event and populate your control with it. Carl Rapson "Moe" wrote in message ... I need the VBA code to open a form from another form and display the data currently in a control of the first form in a control of the second form by clicking a button. I know about stLinkCriteria but some times mor flexibility is needed. I tried [Form2]![Control2]=Me![control1] after the "DoCmd.OpenForm.." in the "OnClick" property of the button but it did not work. Any idea?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
