Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Cascading combo box error

    Hello I have to add two extra columns to my look up table StateCategory and StateServicesCovered




    Right now if the users pick a code from the MER Code drop down box, it populates 2 to 3 fields, now I have to add two more columns. Here is what I have so far

    Code:
    Private Sub MERCodes_AfterUpdate()
    Me.Catagory_for_hours = Me.MERCodes.Column(2)
    Me.Catagory_for_hours.SetFocus
    Me.Catagory_for_hours.Dropdown
    Me.Services_Covered = Me.MERCodes.Column(3)
    Me.Services_Covered.SetFocus
    Me.Services_Covered.Dropdown
    Me.NameofWorkshop = Me.MERCodes.Column(4)
    Me.NameofWorkshop.SetFocus
    Me.NameofWorkshop.Dropdown
    Me.MERCodes.SetFocus
    
    
    
    End Sub

    This is the Code I put in but I'm getting an error message Saying "compiler error - method or data member not found".

    Code:
    Private Sub MERCodes_AfterUpdate()
    Me.Catagory_for_hours = Me.MERCodes.Column(2)
    Me.Catagory_for_hours.SetFocus
    Me.Catagory_for_hours.Dropdown
    Me.Services_Covered = Me.MERCodes.Column(3)
    Me.Services_Covered.SetFocus
    Me.Services_Covered.Dropdown
    Me.NameofWorkshop = Me.MERCodes.Column(4)
    Me.NameofWorkshop.SetFocus
    Me.NameofWorkshop.Dropdown
    Me.StateCategory = Me.MERCodes.Column(5)
    Me.StateCategory.SetFocus
    Me.StateCategory.Dropdown
    Me.StateServicesCovered = Me.MERCodes.Column(6)
    Me.StateServicesCovered.SetFocus
    Me.StateServicesCovered.Dropdown
    Me.MERCodes.SetFocus
    
    
    
    
    End Sub

    Not sure what I'm doing wrong? Can anyone help please??

    this is my lookup table
    Code:
    SELECT      ServicesCovered, CategoryForHours, Codes, CodeID, ID, NameOfWorkshop, StateCategory, StateServicesCovered, EventName, EventLocation
    FROM          dbo.ServCategorylookup_tbl
    it updates this table

    Code:
     
    SELECT      ID, [Parent ID], ServicesCovered, StateCatagory, StateServicesCovered, Catagoryforhours, EventName, NameofWorkshop
    FROM          dbo.TanfActivity_tbl
    Last edited by desireemm; 02-08-12 at 18:27.

  2. #2
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    this is the lookup table I'm using
    Attached Thumbnails Attached Thumbnails lookuptable.jpg  

  3. #3
    Join Date
    Nov 2011
    Location
    Currently in Kabul Afghanistan
    Posts
    47
    I think there is a parity issue between the two tables.

Posting Permissions

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