Thanks for your reply, I now have it working. The problem with directly bounding the option group was that the radio buttons are numeric and the field I'm updating is text. Adding the statement:
[Option group name]=1 (or 2) solved the button issue. Thanks again!
tmorse305
Last Activity: Sep 16 '15, 04:24 PM
Joined: Sep 14 '15
Location:
-
Here is the code for the 2 buttons. Q1_Response is the text box on the form. I also have a screen shot right after the No button is pressed. Q1_Response is also in the screen shot properly updated to "N".
...Code:Private Sub Option787_MouseDown(Button As Integer, Shift As Integer, X2 As Single, Y2 As Single) Q1_Response = "Y" End Sub Private Sub Option789_MouseDown(Button As Integer,
Last edited by Rabbit; Sep 15 '15, 03:43 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.Leave a comment:
-
Incorrect button behavior inside option group
I have a 2 button option group that I am using to allow users to answer a question yes or no. There is a text field in a table that holds the value "Y" or "N" for the question response. On the form where the un bounded option group resides I have created a VBA event procedure for each button when the mouse is clicked(mouse down). The procedures set a text box on the form to "Y" or "N". The text box control...
No activity results to display
Leave a comment: