|
 |
access thread: subforms
Message #1 by "Lesley Schulz" <lesley.schulz@h...> on Thu, 23 May 2002 17:03:22
|
|
I am trying to code an Edit Button to allow edits on a subform.
the parent form is frmLPDB_Main and the child form is frmSubFormDetail
How do I call out a subform to have it allow edits?
Thanks
Lesley
Message #2 by ProDev <prodevmg@y...> on Thu, 23 May 2002 09:27:03 -0700 (PDT)
|
|
--0-1801007489-1022171223=:89265
Content-Type: text/plain; charset=us-ascii
There are several ways. I will approach the locking and unlocking of the subform object itself.
You could create a toggle button that locks and unlocks the subform from the main form as such...
Private Sub MyToggle_Click()
If MyToggle = True Then
MySubForm.Locked = True
Else
MySubForm.Locked = False
End Sub
This will allow you to lock and unlock the subform with a toggle button.
Lesley Schulz <lesley.schulz@h...> wrote: I am trying to code an Edit Button to allow edits on a subform.
the parent form is frmLPDB_Main and the child form is frmSubFormDetail
How do I call out a subform to have it allow edits?
Thanks
Lesley
Lonnie Johnson
ProDev, Builders of MS Access Databases
http://www.galaxymall.com/software/PRODEV
---------------------------------
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
Message #3 by ProDev <prodevmg@y...> on Thu, 23 May 2002 09:45:39 -0700 (PDT)
|
|
--0-96668519-1022172339=:90192
Content-Type: text/plain; charset=us-ascii
If you were just wanting to know how to access the property in the subform, then you would say...
Me![MySubFormName].Form.AllowEdits = True
Lesley Schulz <lesley.schulz@h...> wrote: I am trying to code an Edit Button to allow edits on a subform.
the parent form is frmLPDB_Main and the child form is frmSubFormDetail
How do I call out a subform to have it allow edits?
Thanks
Lesley
Lonnie Johnson
ProDev, Builders of MS Access Databases
http://www.galaxymall.com/software/PRODEV
---------------------------------
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
Message #4 by "Lesley Schulz" <lesley.schulz@h...> on Thu, 23 May 2002 22:25:28
|
|
> --0-96668519-1022172339=:90192
Content-Type: text/plain; charset=us-ascii
If you were just wanting to know how to access the property in the
subform, then you would say...
Me![MySubFormName].Form.AllowEdits = True
Lesley Schulz <lesley.schulz@h...> wrote: I am trying to code
an Edit Button to allow edits on a subform.
the parent form is frmLPDB_Main and the child form is frmSubFormDetail
How do I call out a subform to have it allow edits?
Thanks
Lesley
Lonnie Johnson
ProDev, Builders of MS Access Databases
http://www.galaxymall.com/software/PRODEV
---------------------------------
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
Thanks that worked!
|
|
 |