Warning message in Forms

[CRDF]

Hi.
Form using the Filter Table method is refreshed via button’s Action, to update a linked TableView in a Subform.
It works fine but every time there’s the annoying warning
“The content of current form […]”.
How to block this?

Thanks in advance!

[Villeroy]

@CRDF

“The content of current form […]”.

… needs to be saved?
Make sure that the confirmation button for the filtering main form

• belongs to the filtered subform by dragging the button’s icon to the right form’s icon in the forms navigator.
• takes away the focus from the main form to the subform which will save the main form prop “take focus”=yes).
• refreshes the filtered main form.

Add some cancel button belonging to the filtering main form, so you can cancel (reset) the input of filter criteria in order to avoid the same message when moving to another (sub-)form without confirmation.

[CRDF]

For due credits an reference, I’m elaborating on top of Formulario casella scelta condizionata
soluzione senza macro.
It is a table for “details” from “Product” models.

@Villeroy

belongs to the filtered subform by dragging the button’s icon to the right form’s icon in the forms navigator.

Ok

@Villeroy

• takes away the focus from the main form to the subform which will save the main form prop “take focus”=yes).
• refreshes the filtered main form.

?

[Villeroy]

ListboxInCascata.odb (33.5 KB)

[CRDF]

LB_FTMethod.odb (31.0 KB)
Goal is to get rid of the message!
ModelDetails = possible features for models.
REM: up to now only model 12 = “+ gambaletto” has 2 “specifications” inserted.

[Villeroy]

With my version of the form, I never get the warning, unless I change a list box and then close the form with unsaved data. In this case, I definitively want that warning which allows me to save, not save or cancel the unloading of the form.

[CRDF]

So why this version shows it wIthout closing the forms?
ListBox1: select Product
>> updates ListBox2 according to Product
ListBox2: select Model
>> to open the TableControl “model details” according to Model
MESSAGE

[Villeroy]

In your version of the form, the green button belongs to the same form as the second list box. You modify the form, and then you click the button which tries to reload the modified form. In my version, the first button saves the first form before refreshing the second form, and the second button saves the second form before refreshing the 3rd form.

[CRDF]

No more MESSAGE
Solution = the placing of buttons!

Thanks!