[Solved] Filter/Navigation bar Question

Creating and using forms

[Solved] Filter/Navigation bar Question

Postby gkick » Sun May 17, 2020 7:22 am

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
Last edited by gkick on Sat May 23, 2020 8:10 am, edited 1 time in total.
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 250
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Filter/Navigationbar Question

Postby UnklDonald418 » Thu May 21, 2020 8:20 pm

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.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1322
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Filter/Navigationbar Question

Postby gkick » Sat May 23, 2020 8:09 am

@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
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 250
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile


Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests