Combo box values and continuous forms

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

  1. SidVicious

    SidVicious

    Joined:
    Jul 6, 2011
    Messages:
    1
    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
    Messages:
    16
    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. Ian Anderson

    Using a continuous form's filter to generate a report.

    Ian Anderson, Apr 12, 2011, in forum: General Software
    Replies:
    1
    Views:
    589
    Ian Anderson
    Apr 12, 2011
  2. haservices

    Access: Select a record in continuous subform

    haservices, Apr 20, 2011, in forum: General Software
    Replies:
    1
    Views:
    498
    haservices
    Apr 20, 2011
  3. Zeroeu

    Combobox in Continuous Form with Textbox

    Zeroeu, Jun 1, 2011, in forum: General Software
    Replies:
    1
    Views:
    648
    apr pillai
    Jul 23, 2011
  4. A_Barnes
    Replies:
    1
    Views:
    739
    apr pillai
    Jul 23, 2011
  5. KrisDdb

    Using values from combo box to generate a Report

    KrisDdb, Aug 29, 2011, in forum: General Software
    Replies:
    0
    Views:
    746
    KrisDdb
    Aug 29, 2011
Loading...

Share This Page