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

  • If you want to display the content of the combo box control, then you need to use the syntax that chooses the correct column in the combo box row properties. It should look something like:stDefect = Me.DefectCategory.Column(X)where X is the column number where the Defect Category is displayed. Note that the columns numbering begins with 0, so in many cases it would be Column(1).

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!