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
|
|||
|
|||
sub form
i have a Main form with sub form A and sub form B
i run the following code in the Main form, it works. i also wish to run the following code in sub form B but seems the code cannot recognize [sub form A] in [sub form B]. how can i solve it? Another question : Can i combine line "Closed" and "Cancelled" into 1 line? thanks a lot. ******************************* Private Sub Form_Current() Dim assignperson As String assignperson = CurrentUser() If [sub form A]!assignee assignperson Then Me.AllowEdits = False ElseIf Status = "Closed" Then Me.AllowEdits = False ElseIf Status = "Cancelled" Then Me.AllowEdits = False ElseIf [sub from A]!assignee = Null Then Me.AllowEdits = True Else Me.AllowEdits = True End If End Sub |
#2
|
|||
|
|||
Hi Tony
To reference subforms the general expression is as follows: forms!myMainForm!mySubForm.Form Hope this helps Maurice St-Cyr Micro Systems Consultants, Inc. i have a Main form with sub form A and sub form B i run the following code in the Main form, it works. i also wish to run the following code in sub form B but seems the code cannot recognize [sub form A] in [sub form B]. how can i solve it? |
#3
|
|||
|
|||
i find all the combinations but still fail to find the full path of the
subform is there any way to check it out? Thanks a lot. "StCyrM" ¦b¶l¥ó ¤¤¼¶¼g... Hi Tony To reference subforms the general expression is as follows: forms!myMainForm!mySubForm.Form Hope this helps Maurice St-Cyr Micro Systems Consultants, Inc. i have a Main form with sub form A and sub form B i run the following code in the Main form, it works. i also wish to run the following code in sub form B but seems the code cannot recognize [sub form A] in [sub form B]. how can i solve it? |
#4
|
|||
|
|||
Hi Tony
I sent you the proper syntax to accomplish the task. Can you post the names of your forms and also the syntax that you are using to access your subform? Best regards Maurice St-Cyr Micro Systems Consultants, Inc. i find all the combinations but still fail to find the full path of the subform is there any way to check it out? Thanks a lot. "StCyrM" ¦b¶l¥ó ¤¤¼¶¼g... Hi Tony To reference subforms the general expression is as follows: forms!myMainForm!mySubForm.Form Hope this helps Maurice St-Cyr Micro Systems Consultants, Inc. i have a Main form with sub form A and sub form B i run the following code in the Main form, it works. i also wish to run the following code in sub form B but seems the code cannot recognize [sub form A] in [sub form B]. how can i solve it? |
#5
|
|||
|
|||
Thanks a lot Maurice
i should have found the path but it is strange in result. i posted for assistance in formcoding newsgroup. "StCyrM" ... Hi Tony I sent you the proper syntax to accomplish the task. Can you post the names of your forms and also the syntax that you are using to access your subform? Best regards Maurice St-Cyr Micro Systems Consultants, Inc. i find all the combinations but still fail to find the full path of the subform is there any way to check it out? Thanks a lot. "StCyrM" ¦b¶l¥ó ¤¤¼¶¼g... Hi Tony To reference subforms the general expression is as follows: forms!myMainForm!mySubForm.Form Hope this helps Maurice St-Cyr Micro Systems Consultants, Inc. i have a Main form with sub form A and sub form B i run the following code in the Main form, it works. i also wish to run the following code in sub form B but seems the code cannot recognize [sub form A] in [sub form B]. how can i solve it? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Default values to load up automatically in a form based on value entered in another form | Anthony Dowd | Using Forms | 8 | August 12th, 2004 08:53 AM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
copying a form | Jim VanGordon | Using Forms | 3 | July 30th, 2004 03:14 AM |
Searching Records | Melissa Lambino | New Users | 6 | July 20th, 2004 04:51 AM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |