Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: Option box values to table field

    Hi I am trying to create an access form that will store a value from an option box selection into a table.

    I am using an option group with 5 options buttons.

    What I would like to be able to do is store the selection into the appropriate table.



    To expand

    I have a table with 5 fields and would like to be able to add a record 'figure 1’ to a field depending on what option button is selected. I.e.

    If option button 1 is selected then add a new record ‘1’ to field 1

    If option button 2 is selected then add a new record ‘1’ to field 2

    If option button 3 is selected then add a new record ‘1’ to field 3

    If option button 4 is selected then add a new record ‘1’ to field 4

    If option button 5 is selected then add a new record ‘1’ to field 5



    If possible I would like to be able to do this from a button click.



    Any help would be gratefully appreciated as I have spent the last week trying to do this.

    I thought it would be easy, but……..



    Thanks



    Bella

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Tried using a "Select Case" statement yet?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •