Control on subform / combo box requesting parameter

Access Discussion in 'Microsoft Office' started by Barrie Brown, Feb 16, 2017.

  1. Barrie Brown

    Barrie Brown

    Joined:
    Feb 16, 2017
    Likes Received:
    0
    I am a Newbie in Access and have the following in my database
    Tables:
    tblProducts
    tblCategory
    Forms:
    frmQuote
    SubForm:
    frmQuoteDetails which contains two combo boxes,
    CategoryID with Control Source = CategoryID, Row Source = SELECT [tblCategory].[CategoryID], [tblCategory].[Category] FROM [tblCategory] ORDER BY [Category]
    Additionally on the CategoryID combo box is this AfterUpdate event procedure:

    Private Sub CategoryID_AfterUpdate()
    Me.ProductID.RowSource = " SELECT ProductName From tblProducts WHERE CategoryID = " & " Me.CategoryID "
    Me.ProductID = Me.ProductID.ItemData(0)
    End Sub

    ProductID with Control Source and Row Source both empty, and Row Source Type as Table/Query.

    On running the After Update procedure I get "Enter Parameter Value for Me.CategoryID

    I would appreciate any assistance
     
    Barrie Brown, Feb 16, 2017
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. djsmiler

    Access Access 2003 Value in a combo box

    djsmiler, Sep 6, 2007, in forum: Microsoft Office
    Replies:
    1
    Views:
    460
    Temmu
    Sep 6, 2007
  2. rajnikant82

    Access ms access using combo box

    rajnikant82, Dec 16, 2008, in forum: Microsoft Office
    Replies:
    2
    Views:
    694
    rajnikant82
    Dec 17, 2008
  3. spike250

    Access MS Access Combo Box Help

    spike250, Aug 6, 2009, in forum: Microsoft Office
    Replies:
    0
    Views:
    614
    spike250
    Aug 6, 2009
  4. spike250

    Access Combo Box / Report Help in MS Access 2003

    spike250, Aug 28, 2009, in forum: Microsoft Office
    Replies:
    0
    Views:
    622
    spike250
    Aug 28, 2009
  5. A_Barnes
    Replies:
    1
    Views:
    1,018
    apr pillai
    Jul 23, 2011
  6. francisd

    Access MS Access Limiting Combo Box Options

    francisd, Jan 27, 2012, in forum: Microsoft Office
    Replies:
    0
    Views:
    495
    francisd
    Jan 27, 2012
  7. mbpros

    Outlook Outlook is Requesting Data From the Exchange Server

    mbpros, Jul 11, 2012, in forum: Microsoft Office
    Replies:
    1
    Views:
    1,451
  8. Michael Hawks

    Access Reference Subform's Control

    Michael Hawks, Sep 28, 2016, in forum: Microsoft Office
    Replies:
    0
    Views:
    305
    Michael Hawks
    Sep 28, 2016
Loading...