Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2013

    Unanswered: Cascading Combo Boxes

    I have a web database in Access 2010 that is based off of the desktop product inventory database template that you can download from within Access.
    I have one form to create a purchase order that pulls a list of suppliers from the 'Suppliers' table, manufacturer information from the 'Manufacturers
    table, and product information from the 'Products' table. What I am trying to accomplish is when adding a line item (product to purchase), you choose the supplier at the top of the main form which limits the manufacturers in the subform that the supplier has which then limits the available part numbers in the last box. I have attached a screenshot to make this more clear. The issue is that there isn't a manufacturer field in the suppliers database, so there isn't a direct way to accomplish what I want.

    By default in the template, you can't select a Manufacturer or anything in the subform until you choose a supplier. The fields are locked through an AfterUpdate expression in the suppliers combo box. Once I choose the supplier, the subform unlocks (well, most of it). For some reason, after choosing a supplier, I can choose a product that the supplier carries but I can't choose a manufacturer first. The list appears, but I can't click on anything. If I choose a product, though, the Manufacturer Name field populates with the corresponding manufacturer.

    How can I make it so that the manufacturer combo box is limited by the supplier combo box, and the products combo box is limited by the manufacturer combo box?

    Please let me know if I need to explain something else or if you need more information. Thanks in advance for any help!

    Combo Box Details:

    Supplier Combo Box: (Main Form)
    Control source - 'SupplierID'
    Name - 'cboSupplierID'
    Row Source -
    SELECT Suppliers.ID, Suppliers.Company FROM Suppliers ORDER BY Suppliers.Company
    After Update - See attached "cboSupplierID-AfterUpdate1.png" "cboSupplierID-AfterUpdate2.png"

    Manufacturer Combo Box: (Sub Form)
    Control source - 'ManufacturerName'
    Name - 'cboMFGID'
    Row Source -
    SELECT [Manufacturers].[ID], [Manufacturers].[Company] FROM Manufacturers ORDER BY [Company];
    Product Combo Box: (Sub Form)
    Control source - 'ProductID'
    Name - 'cboProductID'
    Row Source:
    SELECT Products.ID, Products.ProductName FROM Products WHERE [SupplierID]=[Forms]![PurchaseOrderDetail]![cboSupplierID] ORDER BY Products.ProductName;
    After Update - See attached image "cboProductID-AfterUpdate.png"
    Attached Thumbnails Attached Thumbnails cboProductID-AfterUpdate.PNG   cboSupplierID-AfterUpdate1.PNG   cboSupplierID-AfterUpdate2.PNG   accessforum1.PNG  
    Last edited by RossIV; 07-15-13 at 14:27.

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Cannot help you with this, but with 140 members having read your thread, without a single response, just wanted you to know that we're not simply ignoring you, but really have no advice to give.

    Very few, if any, of the experienced Access developers, here, are experienced with Access web-based databases. Almost anyone here could help you with cascading comboboxes, using VBA code. The problem, as I understand it, is that Access web-based databases can only be developed using Macros, and with the exception of a couple of highly specialized Macros, we very seldom use them; as a rule, they are simply too inflexible for serious development.


    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jul 2013
    That's what I figured. My main reason for using the web database was to push to Sharepoint since we use that internally for nearly everything else, but it only pushes the tables. Silly me for assuming that it pushed the entire interface. That would have been entirely too easy.

    Thank you anyway!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts