Page 1 of 1

[Solved] Filter/Navigation bar Question

Posted: Sun May 17, 2020 7:22 am
by gkick
Hi,

I have a TableControl which is based on a query sourcing data from a number of tables and also contains some calculated fields rendering the control read only.

As such the Nav Bar refuses to work. Could I use a filter table as a workaround? Or would a View be an alternative ? Any other options?
Thank you, keep safe

Re: Filter/Navigationbar Question

Posted: Thu May 21, 2020 8:20 pm
by UnklDonald418
The Nav Bar should work for Table Controls displaying data from a read only source. Of course, the options relating to data manipulation will be disabled.
Try adding another Navigation control to your existing form.
If that fails it could be an issue with that form so try creating a new one.
If the table control is on a SubForm be sure to select Parent Form for the Navigation bar option on the Data tab on the Form Properties dialog.

Re: Filter/Navigationbar Question

Posted: Sat May 23, 2020 8:09 am
by gkick
@UnklDonald418
Thank you, checked out the forms hierarchy, no prob, added another bar, same prob
created a blank form, added the tablecontrol and navbar , all worked with the exception of a concatenated field aka "Terms" ||' days' which does not like the auto filter,

muchas gracias