Results 1 to 3 of 3
  1. #1
    bane is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    6

    Question is it possible to sum values from 3 combo boxes?

    I am a total newbie to Access, and I need to make a GCS form like this in Access for my homework. is it possible? I made 3 combo boxes with values like in the linked page, and a text box to show the result. But i got stucked...



    Values from combo boxes and the text box don't need to be stored in any table, i need them for printing.

    any ideas?

  2. #2
    bane is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    6
    in JavaScript is easy to make something like this, but in access...
    can this be made with expression builder?

  3. #3
    bane is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    6

    Talking yes, it is possible :)

    well, i managed to solve the problem this way :

    3 combo boxes with text value lists

    3 text boxes with the "swich" function to change text from combo boxes to numbers
    Code:
    =Switch([Combo1]="text value1";numbered value1;[Combo1]="text value2";numbered value2;...)
    1 text box with the result
    Code:
    =[textbox1] + [textbox2] +[textbox3]

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 08-01-2009, 06:48 AM
  2. combo boxes
    By googenfrog in forum Forms
    Replies: 3
    Last Post: 07-03-2009, 05:41 PM
  3. Replies: 7
    Last Post: 05-16-2009, 08:08 AM
  4. Replies: 3
    Last Post: 02-26-2009, 10:17 AM
  5. combo boxes
    By labrams in forum Forms
    Replies: 0
    Last Post: 04-20-2006, 09:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums