Toggle buttons

[Amit112]

Hi Guys,
I am having a terrible time with this database. There is now a new problem.

On the side I have toggle buttons. They read ACTIVE ON HOLD CLOSED

The problem is, every time the record changes, the button remains the same. I need it to pop back out every time I change the record. So if I go to record 2, it has to let me choose again which one I would like to press. Thanks guys. I have no idea what im doing so a detailed explanation would help.

 

[mdmilner]

The only way I can think of to manage this requires you to control your navigation through the records with custom buttons instead of using the default/built-in recordselector or navigation buttons (those arrows at the bottom of the form)

If you're not already doing it, create a new button on your form, then in the wizard, select record navigation and then "Next Record". Open up the vba module behind it and modify it to include code that modifies your toggle button controls.

Here's an example of how to use a command button to toggle the apparent position of a toggle button called togMine

Private Sub Command38_Click()

If Me.togMine.Value = True Then
  Me.togMine.Value = False
Else
  Me.togMine.Value = True
End If

End Sub

What you'll end up needing to do is figure out what rules determine the position of your toggle buttons. For example, is it the value in a field in the same record? If yes, then you'd do something like (this assumes you have a value of True/False in fieldname1

Me.toggleName1.Value = Me.fieldname1
Me.toggleName2.Value = Me.fieldname2
Me.toggleName3.Value = Me.fieldname3

Mike

 

[Amit112]

Hi Mike,
Thanks for your help but it is not working. Any other ideas?

 

[mdmilner]

Sorry - this works. Tested it to be certain as I was typing it out.
What specifically seems to be the problem?
What do you not understand?

The only thing I could add is, instead of setting it so that it reads a stored value in the record, just set it so hitting the 'next record' button sets the toggle button to 'false'

False is the 'up'/unclicked position.

Mike