[libreoffice-users] Re: Can I reload a form based on a parameter query?

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:lo@ptoye.com
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: users+unsubscribe@global.libreoffice.org
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