Results 1 to 3 of 3

Form works! Now, user selects from combo & adds record want next choice in combo box to appear

  1. #1
    GinaFlan is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2014
    Location
    Texas
    Posts
    68

    Talking Form works! Now, user selects from combo & adds record want next choice in combo box to appear

    My Form works !!!!




    Each user/department has a list of goals. After they highlight their first goal and "Add" the record cmdADD I would like for their next goal to appear in the combo box automatically. What word would I use to search with for this code to make this happen? Would it be "next"

    The combo box is populated by a table.
    Attached Files Attached Files
    Last edited by GinaFlan; 10-16-2014 at 07:33 PM.

  2. #2
    llkhoutx is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    USE ADO or DAO to find the current value in the combo box row source, move to the next record, save that value in the combo box and call all the combo box AfterUpdate event.

  3. #3
    GinaFlan is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2014
    Location
    Texas
    Posts
    68
    Ok great thank you

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

Similar Threads

  1. Replies: 6
    Last Post: 08-20-2014, 06:43 PM
  2. Replies: 9
    Last Post: 08-09-2014, 01:32 PM
  3. Replies: 1
    Last Post: 05-23-2012, 11:45 AM
  4. Replies: 2
    Last Post: 11-30-2011, 08:44 PM
  5. Replies: 1
    Last Post: 08-03-2009, 08:24 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
  •  
Tech Forums: Microsoft Office Forums