A2K "With Reports" Not Changing Caption for User

[Andy]

Hi;

Have this Sub in the OnClick Event of a cmdButton:
Note: Use the same rpt layout for other cmdButtons, the Subs change the
Criteria and lblCaptions

Private Sub cmdRecords_Click()
Dim Msg, Style, Title, Help, Ctxt

Application.Echo False
DoCmd.OpenReport "rptRecords", acViewDesign
With Reports("rptRecords")
.Controls("lblrptSortType").Caption = "Sorted by Contract Date"
End With

DoCmd.Close , , acSaveYes
Application.Echo True
DoCmd.OpenReport "rptRecords", acPreview
End Sub

It changes the lbl Caption for the "sa" running full A2K and in Runtime but
NOT for the User in either full A2K or Runtime.

The permissions for the User are set to Open/Run, Read Design, Modify Design
and for the "sa" the Administer is also selected.

Did try adding Administer permission for User. That didn't work.

Can someone point me in the right direction to overcome this?

Thank You for reading this post.

Andy

 

[Paolo]

Hi Andy,
did you set on the DB open exclusive for the user?
I'm asking 'cause changes are discarded if other user are connected at the
times of the changes.

HTH Paolo

 

[Andy]

Paolo;

Thanks for answering.

No. The DB is not set to Open Exclusive for the User.

There is only one User at a time. The Dbase is not shared nor networked.

 

[Andy]

Paolo;

Thank You.

Added "/excl" to the end of the shortcut.

It worked. "With Reports" doing what it is supposed to.

Andy