Toggle button vs Command button

[Steve Stad]

I was using command buttons to write text in a text box. The command buttons
work fine. I was thinking of using toggle buttons because toggle buttons
change color/shading when pressed. The toggle button writes the text in the
box but I get a 'Run-time error '2115' - The macro or function set to the
BeforeUpdate or ValidationRule property for this field is preventing dbname
from saving data in the field. END/DEBUG. I am using the 'OnClick' Event
to write the text. Do I need code in another event?

Private Sub Toggle21_Click()
HelpWindow.SetFocus
HelpWindow.Text = "Writes this text"
End Sub

 

[Tom van Stiphout]

On Fri, 28 May 2010 07:14:01 -0700, Steve Stad

This may be related to trying to set the focus at an inopportune time.
Fortunately it is not necessary, if you replace your two lines with:
HelpWindow.Value = "Hello World"
(.Text requires the control to have focus; .Value does not)

-Tom.
Microsoft Access MVP

 

[Steve Stad]

Thanks Tom,

This (your) code works fine for the toggle buttons. i.e., I removed the
..setfocus line.
Private Sub Toggle23_Click()
HelpWindow.Value = "CTR Rule - toggle button"
End Sub
.....
Is there a way for a toggle button shading to change from pressed to
Unpressed when another toggle button is pressed. Right now each toggle
button is highlighted as pressed unless you press it again.