Results 1 to 2 of 2
  1. #1
    dman2522 is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Oct 2017
    Posts
    1

    Dynamic combo box in a datasheet form

    I have a form in which one combo box's options are dynamically updated based on the selection of the first combo box. I want this form to exist in datasheet view. The combo boxes in datasheet view essentially become columns so the goal is to have a selection in column one impact the options for column 2. The query I am running to change the options for column 2 is tied to the entire combo box so a change made anywhere in the first column impacts all the previous rows for the second column. Here is an example:

    Add an entry in row 1 of form. Select Role for Skill Category which presents me with the correct options for Skill Description.

    Click image for larger version. 

Name:	Access Help 1.PNG 
Views:	11 
Size:	3.6 KB 
ID:	30776

    Add another entry for row 2 with Skill Category as Role. Everything still works as expected

    Click image for larger version. 

Name:	Access Help 2.PNG 
Views:	11 
Size:	4.6 KB 
ID:	30779

    When I move to row 3 I select domain for Skill Category. The options in Skill Description are correct but it removes the previously selected options for rows 1 and 2.

    Click image for larger version. 

Name:	Access Help 3.PNG 
Views:	11 
Size:	4.9 KB 
ID:	30780



    Lastly, when I add a 4th row and select role it removes the Skill Description from row 3 but the Skill Descriptions for row 1 and 2 reappear.

    Click image for larger version. 

Name:	Access Help 4.PNG 
Views:	11 
Size:	6.1 KB 
ID:	30781


    Appreciate any and all help,
    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you cant have dynamic combo box in datasheets.(tables)
    you can in forms. Just use a form.
    Last edited by ranman256; 10-13-2017 at 04:49 AM.

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

Similar Threads

  1. Cascading combo boxes in datasheet form
    By gemadan96 in forum Forms
    Replies: 1
    Last Post: 06-20-2014, 09:59 AM
  2. Replies: 3
    Last Post: 02-15-2014, 02:59 AM
  3. Replies: 1
    Last Post: 06-26-2012, 07:23 AM
  4. Replies: 1
    Last Post: 06-25-2012, 02:22 PM
  5. Dynamic Datasheet Caption
    By Jester0001 in forum Forms
    Replies: 4
    Last Post: 05-30-2012, 01:13 PM

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