filtering a tabular form according to calculated text box

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
 
R

roger

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Filtering a Lookup Wizard field in a tabular form through a button 3
Filter tabular form by combo box 0
Change the font color/background of a text box depending on value 6
adding text box 1
PASSING VALUES IN CALCULATED FIELDS ON FORMS.. PLEASE HELP 3
Need combo box to refresh when moving to new record 2017 1
check box to update text box 10
Calculated control not displaying zero when recordset is empty on 5

Top