Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Simplest way is to create a query that generates a dialog prompt. As a constraint in the query, type a placeholder name to identify the value, preceded by a colon ( : ), i.e, :enter_variable . When you run the query, you will get a dialog box that requests the value for enter_variable, and then displays the query using the variable you entered into the dialog box. It will look like this:

image description

The query can be used as the source for the form. h/t Nocton@ooForum

Push button would be more sophisticated. For some detail about programmatically navigating through records in a form, see LO form Q/A Open form via macro in Libreoffice Base.