subfrom controls

[Hasan]

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

 

[Dirk Goldgar]

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.

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.