enabling/disabling buttons problem!?

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

Hi,

I've got a form with a button and I want the button to get disabled if
pressed for this record. So far, so good. But I then want it enabled
again for the next record! And the same goes there: if button pressed
then disable it for THIS record, then when going to the NEXT record the
button should be enabled again.

Any help is appreciated!

Jerome
 
In the Click Event of the button, put this code

..... perform what the button is supposed to do then ...
[SomeOtherControlOnTheForm].SetFocus
[ButtonName].Enabled = False

When you change records the default button state of enabled will return.
 
Further to my last post, the button does not come back enabled when you
change records, so in the On Current Event of the form put this code

[ButtonName].Enabled = True
 
Hello Jerome.

Jerome said:
I've got a form with a button and I want the button to get disabled
if pressed for this record. So far, so good. But I then want it
enabled again for the next record! And the same goes there:
if button pressed then disable it for THIS record, then when going
to the NEXT record the button should be enabled again.
Click to expand...

And, I guess that whan the user gets back to the first record, the button
should be still disabled?
You could use a Yes/No column in your table (Done), and use a ToggleButton
(tglDone) instead of a CommandButton to
display it's value. In the beginning of the BeforeUpdate eventprocedure of
the ToggleButton,
use something like this:

If tglDone = 0 Then
Cancel = True
tglDone.Undo
Exit Sub
End If
 
Yes indeed! It was the 'Current Event' that I missed.

Thanks.

Further to my last post, the button does not come back enabled when you
change records, so in the On Current Event of the form put this code

[ButtonName].Enabled = True

:

Hi,

I've got a form with a button and I want the button to get disabled if
pressed for this record. So far, so good. But I then want it enabled
again for the next record! And the same goes there: if button pressed
then disable it for THIS record, then when going to the NEXT record the
button should be enabled again.

Any help is appreciated!

Jerome
Click to expand...
Click to expand...
 
That's a good idea too! Thanks.

Wolfgang said:
Hello Jerome.




And, I guess that whan the user gets back to the first record, the button
should be still disabled?
You could use a Yes/No column in your table (Done), and use a ToggleButton
(tglDone) instead of a CommandButton to
display it's value. In the beginning of the BeforeUpdate eventprocedure of
the ToggleButton,
use something like this:

If tglDone = 0 Then
Cancel = True
tglDone.Undo
Exit Sub
End If
Click to expand...
 
Back
Top