I am doing a redesign of one of our customer profile screens and my sales people asked for check boxes to be used to identify products that their clients are interested in. I have designed the screen, linked everything to SQL and was testing it when I ran into an issue that some check boxes will work and others are not able to be clicked. I am running SLX 7.5.3 if that helps....its really off, 50% of the boxes work fine but some of them are just not editable

Are these checkboxes 1:M or 1:1 ? It could be that the users are in a team that doesn't have permission to edit ? Or, if they are 1:M then this doesn't apply. The next issue it could be is a problem with the security identifier. If you go back into DBMgr and add a new field (called Dummy) this should extend it again and make it work. Let us know if that's the issue.

Mike

Thanks, I actually created new panels and then remade the check boxes and it worked fine, not sure why it wasnt working...now I have another question....I have an edit button so that you must click that edit button before you can check the checkboxes....on some of the panels it works and on others you can check boxes without hitting the edit button....ever seen that? How would I tie them to the edit button...I am modifying an existing template from a previous DBA

Adam

Mike

Thanks, I actually created new panels and then remade the check boxes and it worked fine, not sure why it wasnt working...now I have another question....I have an edit button so that you must click that edit button before you can check the checkboxes....on some of the panels it works and on others you can check boxes without hitting the edit button....ever seen that? How would I tie them to the edit button...I am modifying an existing template from a previous DBA

Adam

I think what you are seeing is a form loading issue. checkboxes are notorious for that, given their state changes on loading.

So, if you open the form and, on the WhenChange add an option like this:

<p>If Not Form.IsReading
SetButtonChkBoxState
' Do your stuff

End If

Where "Form" is the main form container name. So, you would do something like:

<p>
Sub SetButtonChkBoxState

 Select Case btnName.Enabled

  chk1.Enabled = btnName.Enabled
  chk2.Enabled = btnName.Enabled

 End Case

End Sub

This will then set the checkboxes to Enabled/Disabled based on state of button. The Click event of button calls the same routine.