Combo box values and continuous forms

Discussion in 'Other Software' started by SidVicious, Jul 6, 2011.

  1. SidVicious

    SidVicious

    Joined:
    Jul 6, 2011
    Likes Received:
    0
    Hello, I am rather new to Access programming, and have a problem that I haven't been able to solve despite hours of looking on-line.

    My basic problem is that I have a continuous form with one text box adjacent to one combo box. The text box values come from one table, the combo box values from a related table. On the form the combo boxes allow the user to rate what is in the text box (rating of 1-5). After these 20 items have been rated, I want to submit those values (both the text box and combo box) as unique records in a third table, whose fields are related to the original two tables. I can't seem to find a way for Access to treat each combo box value on the form as a unique value. Any advice would be greatly appreciated. Thanks
     
    SidVicious, Jul 6, 2011
    #1
    1. Advertisements

  2. SidVicious

    apr pillai

    Joined:
    Jul 20, 2011
    Likes Received:
    0
    Create a new field on the same table from where the textbox value is taken; for recording the rating value selected from the combobox control,

    Set the Control Source property of the Combo Box to the new field to record the combobox selection.

    When the user selects the rating number it will be recorded on the same table of the Textbox.
     
    apr pillai, Jul 21, 2011
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. spike250

    Access MS Access Combo Box Help

    spike250, Aug 6, 2009, in forum: Microsoft Office
    Replies:
    0
    Views:
    545
    spike250
    Aug 6, 2009
  2. Ian Anderson
    Replies:
    1
    Views:
    742
    Ian Anderson
    Apr 12, 2011
  3. haservices

    Access Access: Select a record in continuous subform

    haservices, Apr 20, 2011, in forum: Microsoft Office
    Replies:
    1
    Views:
    654
    haservices
    Apr 20, 2011
  4. Zeroeu

    Combobox in Continuous Form with Textbox

    Zeroeu, Jun 1, 2011, in forum: Other Software
    Replies:
    1
    Views:
    807
    apr pillai
    Jul 23, 2011
  5. A_Barnes
    Replies:
    1
    Views:
    972
    apr pillai
    Jul 23, 2011
  6. KrisDdb
    Replies:
    0
    Views:
    834
    KrisDdb
    Aug 29, 2011
  7. StumpyPope

    Can I auto resize a subform in continuous mode

    StumpyPope, Jun 18, 2012, in forum: Other Software
    Replies:
    0
    Views:
    898
    StumpyPope
    Jun 18, 2012
  8. Alan O'Lane
    Replies:
    0
    Views:
    320
    Alan O'Lane
    Feb 19, 2016
Loading...