-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Peter,
> I have a form which at present is based on a parameter query - the > user types in a criterion and only the relevant database rows are > shown.When I press a button a macro does various actions, including > deleting the currently selected row. After all this I want to > reload the form to get the latest version (without the deleted > row). But a straight Form.Reload asks again for the criterion, > which I don't want. > > Is there any way of doing this? The only way I can think of is to > use a dialogue or input box to allow the user to input the > criterion and base the query on a SELECT clause incorporating the > criterion. You could better put the parameter-values in a form and the query in a subform. The values in the form could be saved in a table with only one row. Call it "filter" ore something else, primarykey is a boolean yes-no-field. So you could type the parameter, change to the subform and the subform will be reloaded. It will also be reloaded without asking again for the paramter, because this is written down in the mainform. Regards Robert - -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBAgAGBQJYhlsvAAoJELDKYwaoS9AIA2oQAIVHOOeYxoDNA4ZTg3xSNd3Z TLi8XosfAzjeef9KpUJlj4YI5r4ybB2HdJgKz9iEeOvQYe871DoDx87w7PNdRRuu WuimnIhDshPMdvGaBNJeZ4NlrlUMb2cAuGfyLlPBG8z0hqyLgDBU2qRIkHta+I8Y KmQgjmrPLzI1/M+rIDaUhYn0hxYqg0AM4vPRk+a1z1brdeWEwWxqPcHZ+cWqRUGg p+SaiBsU9BLDrUZkKhCpxQp2NXm6hy3RmS/UY1qiP5X8YM+//3BjjwT6l25HhEs4 RDkOJGiI2P+bffqNzHmdMgz3JyNMCYPINfhV7NkRL95ZdmzDOK5iOXDUGJyXjCPx rSSoh3ncl9VWqvam15x1i6ZFZ8iYYbU4xngZsmpT/xH19NrWfvawXDQYcxtrT25E CfAo4tiJXgA+3QhjOkjuxzRGGEHRXUCIau7Cyi6T/HgHziARW7hyttR51Kfb83+l JXuTcjd+5V861km0Kz62XsLthvhIAIFTIE+QI1xeWdzWZUW4oiL1kdZ8OewllYdx kMGFoK3OGPTg7FvIf1zfi6M6PKYL3PWVAzHS/D17R+mGKrC+bue1wrWnZs1fvi0J uN9Ie+WqsySO5Hnvc7aTE19hj5k8ETdYiGE5Kd/LQ3EXko/rNAfJ7oc/bRWSWE4x mV76ym7os90knS+I67NL =oFmg -----END PGP SIGNATURE----- -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
