subfrom controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to disable navigation buttons and Allow Edits of the subform from the Main form. I am using Access 97 and having trouble setting this up.

I do not want to pre set these in the subform as it will be used by users at different levels (ie standard agent and manager).... I wish for a manager to go in through a different screen to be able to edit etc.

Thanks in Advance for any help or suggestions

Hasan
 
Hasan said:
I wish to disable navigation buttons and Allow Edits of the subform
from the Main form. I am using Access 97 and having trouble setting
this up.

I do not want to pre set these in the subform as it will be used by
users at different levels (ie standard agent and manager).... I wish
for a manager to go in through a different screen to be able to edit
etc.
Click to expand...

Try something like this:

With Me.NameOfSubformControl.Form
.NavigationButtons = False
.AllowEdits = False
End With

By "NameOfSubformControl", I mean the name of the control on the main
form that displays the subform. This may or may not be the same as the
name of the form object it displays.
 
Back
Top