Display combo box for just one company

(0) Share

Report

Posted on by Community Member Microsoft Employee

I have added a combo box to a screen in Dynamics SL7, but would like to hide it from all but one company, is this possible?

I added the box at 'one group' customization level which hides it from most users, but when the users in that group log into a different company db they still have the box

Thank you for any help

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Display combo box for just one company

Hi Jeff

Thank you very much.

This worked like a charm.

Do you know any good resources where i can learn more VBA code?
Verified answer

Jeff Trotman 275 on at

Like (0)

Report

Re: Display combo box for just one company

Here's some VBA code that should do it.

While in Customize Mode, select Visual Basic Editor from the Customize menu. From the code window that appears, choose Form1 from the drop down box at the top on the left, and Load from the drop down box at the top on the right.

This should insert this into your code window:

Private Sub Form1_Load

End Sub

Between these two lines, paste this code but change the "ABC" to the CpnyID that you want this to visible in, and "cdocdesc" (in 2 places) to the name of the combo box you added.

Dim strCpnyID As String

Call GetBufferValue("bpes.CpnyID", strCpnyID)

If Trim(strCpnyID) = "ABC" Then

Call setprop("cdocdesc", PROP_VISIBLE, False)

Else

Call setprop("cdocdesc", PROP_VISIBLE, True)

End If

From the Visual Basic Editor, choose File, Close and Return to Solomon Screen and then save your customization like normally. Close the screen and re-open it and the combo box should show (or not) based on the company you are logged into.