filtering a tabular form according to calculated text box

  • Thread starter Thread starter mezzanine1974
  • Start date Start date
M

mezzanine1974

There is a calculated text box on a tabular form. Calculation is based
on other text boxes which are bounded to a table. Everything is fine
except that i can not filter the tabular form according to calculated
text box. When I select the calculated text box, filter button
becoming enable.
Is there anyway to filter the form according to calculated text box?
Thank you
 
Well, you cannot use the FILTER function on an UNBOUND textbox. (the
calculation is moot) But if your form is based on a Query, you could requery.

You'll need a custom button or an onClick event or something to trigger it.
 
Back
Top