Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2014
    Posts
    8

    How to update a combobox with openForm?

    Basically, I'm opening a mask with
    HTML Code:
    DoCmd.OpenForm "MyComboBoxMask"
    and in this mask there's a combobox. What I need to do is try to show in the combobox only some results based on the results of the first mask, instead of showing all the results found in the table is connected to as is doing now. I have tried passing a the "where" parameter in the OpenForm method in order to filter the options, but it doesn't seem to update the these. How could I go about updating the options shown in this combobox? Note: The idea is that in the first mask the user inputs something, and if there is more than one option in the Database then this mask with a combobox shows to make the user select between the available options. Hope this makes sense.

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    This sounds like you are trying to achieve cascading combo boxes - but with forms? (I'm guessing that your "mask" is actually a form??)
    This link might point you in the right direction. http://www.baldyweb.com/CascadingCombo.htm
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    I don't understand what all the "masks" are but I think that a google search or a search of this forum for"cascading combo boxes" may be of help to you.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  4. #4
    Join Date
    Apr 2014
    Posts
    8
    Right! I mean Forms!

    Cascading Comboboxes seem like an option, I will try, only that in these tutorial is inside the same form while I'm trying to open a new one.

  5. #5
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Why open another form though. Why not use combos on one form
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  6. #6
    Join Date
    Apr 2014
    Posts
    8
    I tought of opening a new one for more intituive interface, having a disabled combobox that sometimes is enabled and others disabled after you submit didn't feel too user friendly.

  7. #7
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    I would also go for single form. Cascaded combo's are a pretty familiar interface on web pages for instance, when choosing an address or billing methods.
    Multiple forms open get messy, and need closing / managing, and you can't see what previous option you choose once another form is opened on top.

    You can also use colour as well as enabled/disabled to indicate if control is to be filled out or not
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  8. #8
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by Nightcrawler View Post
    I tought of opening a new one for more intituive interface, having a disabled combobox that sometimes is enabled and others disabled after you submit didn't feel too user friendly.
    I agree with Mintys comments plus you could even hide the combos until needed
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  9. #9
    Join Date
    Apr 2014
    Posts
    8
    Alright! thank you all for your help. I implemented this using the same form.

    Thanks!

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

Similar Threads

  1. Update Combobox List from another value
    By Joakim N in forum Access
    Replies: 7
    Last Post: 10-12-2016, 11:19 AM
  2. Auto update combobox
    By omegads in forum Access
    Replies: 21
    Last Post: 09-07-2016, 06:20 PM
  3. ComboBox after update/reload
    By pmac in forum Programming
    Replies: 1
    Last Post: 11-10-2011, 07:16 PM
  4. Replies: 6
    Last Post: 07-28-2011, 04:07 AM
  5. ComboBox to update picture
    By ron727 in forum Programming
    Replies: 2
    Last Post: 05-21-2009, 06:29 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