filter on string RRS feed

  • Question

  • i have a form with a continuous subform.

    in the subform is a combobox base on a table.

    i want filter the rowsource of the combobox based on a unbound textbox in the main form.

    the textbox on the mainform has as value a string, i want to select on a part of the string

    is that possible ?

    Sunday, July 8, 2018 8:50 AM


  • Sure. Just use the expression builder ([Forms]![MainFormName]![ControlName].[Value]).

    • Marked as answer by tekoko10 Monday, July 9, 2018 2:00 AM
    Sunday, July 8, 2018 10:57 AM