Ask Experts Questions for FREE Help !
Ask
    dannac's Avatar
    dannac Posts: 267, Reputation: 9
    Full Member
     
    #1

    May 19, 2011, 02:45 PM
    Form option button not working
    Code:
    ' Transfers Amount
    If OptionButton1 Then Cells(Nextrow, 4) = TextBox4.Value
    If OptionButton2 Then Cells(Nextrow, 5) = TextBox4.Value


    Problem is with OptionButton2

    OptionButton2 is inputting TextBox value to col 4 and col 5.

    As if OptionButton1 does not get turned off when I select OptionButton2.

    Both option buttons are within a frame on a form.

    OptionButton1 works correctly.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    May 19, 2011, 03:31 PM

    Can you post a file with this form and instructions on testing/seeing the error duplicated?
    dannac's Avatar
    dannac Posts: 267, Reputation: 9
    Full Member
     
    #3

    May 20, 2011, 11:07 AM

    This is fixed... Thanks

    This works
    Code:
    '   Transfers Amount
        If OptionButton1 Then
        Cells(Nextrow, 4) = TextBox4.Value
        Cells(Nextrow, 5) = ""
        End If
        
        If OptionButton2 Then
        Cells(Nextrow, 5) = TextBox4.Value
        Cells(Nextrow, 4) = ""
        End If

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search


Check out some similar questions!

When adding a button to a form, how do you inform the user to go to a specific field? [ 1 Answers ]

Okay, I've created a data entry form in Access 2003. I included a click button for a user to add a new customer to the database. What I am trying to figure out how to do is once the user clicks on the button, the form should take the user to the first data entry field (where the blinking cursor...

Want Button on Access Form for Inserting OLE Object into Table [ 1 Answers ]

Hi. I'm looking for a simple simple simple solution that will allow me to add a button to an Access form. When the button is clicked, a File Dialog box should appear allowing me to pick any file to insert into the OLE package. I've searched every corner of the web and have found a lot of...

Insert -> Local File option not working in Word 2000 [ 1 Answers ]

Hi all, I'm having trouble getting my Insert -> Local File option to work in Word. When I click on it, the Select File window does not pop up. In Fact it doesn't do anything, except for a quick hourglass then back to Normal cursor. I'm using Office 2000 which is running off the...

Go to record on form button [ 3 Answers ]

I want to put a button on the form that pulls a string from a text box and goes to the unique "sorder number" in the form. This will keep my users from having to click next a hundred times to get to a record. I have no time to try and figure out the vb code so if anyone already has an idea how to...


View more questions Search