Use Toggle button to change Field Value?

[Franky G]

Hi,

I've got a table 'tblMaintMode' with one field 'Mode' which will be either 0 or 1. I've got a hidden form timer event checking this value and when it's set to 1 then Access will close for maintenance.

I'd like to have a button on my main form which would be invisible, only I know where it is, which would allow me to toggle the value of the Mode field and display a caption or small message for a few seconds about which mode is selcted, 'normal' or 'Maintenance'.

I've tried a search here and others have certainly asked the same question, but I don't see the actual solutions! Any pointers would be most welcome....off to Google again ;-)

FrankyG

 

[Rich]

Which bit are you looking for help on? you can use the double click event of a "hidden" label graphic etc. to do what you want, just format the control label etc. to appear "hidden"

 

[Franky G]

Sorry, it's the actual code for toggling the value of field 'Mode' that I'm struggling with. Am I right in saying that even if a field on a form is invisible, it can still be active?

FrankyG