Toggle Button on Bound Form

[P5C768]

Is there any way to make the result of a toggle button selection specific to the current record on a bound form? I am using one to display/hide a field and even using me.togglebutton1 seems to apply the selection to every record, rather than just to the current record.

[RuralGuy]

The ToggleButton needs to be bound to a field in the RecordSource of the form for it to act independantly on each record.

[P5C768]

I have it bound to a field on a table. All the other fields on the tab control are boud to fields on the same table as well. However, the toggle button seems to activate all fields in the table i.e if you set the toggle to true, all the records in the table get set to true.

[RuralGuy]

For just this field? Do you have any code running on the Toggle Button? If so, can you post it?

[P5C768]

Yes, for tjust this field. The only code I currently have associated with this toggle button is this:

 
Private Sub TogSA1_AfterUpdate()
    If Me.TogSA1.Value = True Then
        Me.txtSA1.Visible = True
    Else
        Me.txtSA1.Visible = False
    End If
End Sub

Another question. I saw some of your posts regarding the trust center in 2007. I opened my db at home last night in 2003, made some minor changes to the formatting of a form, then opened it again in 2007 today. For some reason, none of my even procedures are working. I have tried creating new trusted locations, moving the db etc. but nothing seems to work. I am not getting a blocked content message when I open the db.

[RuralGuy]

I would use the Click() event rather than the AfterUpdate event. When the db starts acting weird, the first thing I do is *import* the db into a fresh new db and see if the problem follow. http://www.btabdevelopment.com/ts/impnew

[P5C768]

Looks like changing to click() and importing to a new db worked! Thanks as always! Enjoy the snow!

[RuralGuy]

Excellent! Another satisfied customer.
Just finished plowing 12" so I can get my truck out.