Form toggle button conditional colour change

[PDilly]

My PC persisted in making a .RAR file. can you work with that?

[PDilly]

try this one
regard
PDTestDB (2).zip

I deleted WinRAR and just used Win10 to zip it
regards
PD

[Gicu]

Have a look if that is what you want and let us know...
Cheers,
Vlad

[PDilly]

Have a look if that is what you want and let us know...
Cheers,
Vlad

Hi Vlad,

Thank you so much for taking a peek at it.

I can see that you added a public sub and call it from both forms as you originally described
I'm guessing that you had it working at your end but unfortunately, having saved the file here and enabled it, the button refuses to change colour when I exit form2 and return to form1.
it does of change when you move to anther record and back on form1

Have I missed something I should have done first?

Regards
PD

[PDilly]

Have a look if that is what you want and let us know...
Cheers,
Vlad

UPDATE

Hi Vlad,

After a rare flash of inspiration I put your routine call in the unload property of Warning_subform3 (where WARN resides) and it works perfectly. No need for the call in unload of the main input form
Thank you so much for your help.

Is there an easy way of deterimining whether the warnings input form was opened from the member_entry form or the main menu (which isn't in the testDB)? If not, I'll put a second exit button in to handle that.

regards
PD

[PDilly]

UPDATE

Hi Vlad,

After a rare flash of inspiration I put your routine call in the unload property of Warning_subform3 (where WARN resides) and it works perfectly. No need for the call in unload of the main input form
Thank you so much for your help.

Is there an easy way of deterimining whether the warnings input form was opened from the member_entry form or the main menu (which isn't in the testDB)? If not, I'll put a second exit button in to handle that.

regards
PD

Hi Vlad,
All sorted!
I cracked the final problem by adding an IsLoaded test to your code.
It all works perfectly now
Thank you so much for you help and inspiration

Regards
PD

[Gicu]

Glad to hear you got it working!

Cheers,
Vlad