Home Forums Microsoft Access Microsoft Access Using value in combo box based on Foreign key relationship RE: Using value in combo box based on Foreign key relationship

  • August 29, 2013 at 5:59 am

    #1645930

    kwoznica (8/28/2013)

    Disregard my last message. I changed Me.DefectCategory to Me.Combo45.Column(1) and it worked.

    Thanks for that idea.

    That indicates the name of your combobox control is Combo45. Your initial code was trying to find a combobox named DefectCategory on your form. If you change the name of Combo45 on the form to DefectCategory, you would be able to use Me.DefectCategory.Column(1).

    ____________
    Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.