• Registered: 2014-12-02
  • Posts: 136

Topic: Filtering Grid by Combo Box on form

I have two combo boxes and I would like to filter my grid by the selected value from each of the two combo boxes on the form.

I tried using the filter within the tablegrid but that raises an error that the column was unknown.

(frmFitnessJrnl.cbxAthlete.dbItemID=Activities.id_Individual1)

How would I control the grid based on the selected items on the combo boxes on my form? Will I need to use a script?

Thank you,
  Rob

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Filtering Grid by Combo Box on form

For filtering in TableGrid by using ComboBox you must use button with action "Search" (http://myvisualdatabase.com/help_en/com … earch.html) or "SQL query" (http://myvisualdatabase.com/help_en/com … n_sql.html)


Also you can hide Button for filtering (property of button Visible) and use property of ComboBox "Increm.Search" for instand search.
http://myvisualdatabase.com/help_en/com … earch.html

Dmitry.