Robert,
That sounds great - I'm sure I should have thought of this all by myself.
But there's an added complication which I didn't mention before. When the user
types in a criterion, this needs to populate a table on the form. He/she then
selects a row which fills in some fields in the form. the user then has the
option of changing some of them before clicking the button. So it seems that I
need two levels of subform - one for the table and one for the fields (rough
diagram below). Do you know if LO can handle this or will I have to experiment?
Criterion
|
|----Table
|
|----Fields
Best regards,
Peter
mailto:[email protected]
www.ptoye.com
-------------------------
Monday, January 23, 2017, 7:37:14 PM, you wrote:
-----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: [hidden email]
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
If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206067.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML
-----
Peter
--
View this message in context:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206101.html
Sent from the Users mailing list archive at Nabble.com.
--
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
