Code wont refresh help anyone.

  • Thread starter Thread starter Joves
  • Start date Start date
J

Joves

I was provided this Fantastic code...BUT it doesn't
refresh...the minute it finds SupCheckbox true than it
will enable
Budcheckbox to true....

When I scroll to another record checking it it finds one
a
SupCheckbox with no checkmark but Budcheckbox is still
enabled....

Is there anyway to update for it to keep checking and
Enable and Disable Budcheckbox accordingly to our
variables.

If SupChk.Value = True Then
BudCheckbox.Enabled = False
ElseIf SupChk.Value = False Then
BudCheckbox.Enabled = True
End If

Can anyone help? Thanks,
Joves
..
 
Hi,
Where did you put this Code? Sounds like you want it in the form's
Current event.
 
Hi Dan,
BUT it doesn't refresh...the minute it finds SupCheckbox
true than it will enable Budcheckbox to true but if the
users goes to another record which has SupCheckbox with
NO checkmark, Budcheckbox is still enabled!

Please assist.

Thanks,

Joves
-----Original Message-----
Okay, then I don't understand what the problem is.

--
HTH
Dan Artuso, Access MVP


"Joves" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Hi,

If SupChk.Value = True Then
BudCheckbox.Enabled = False
ElseIf SupChk.Value = False Then
BudCheckbox.Enabled = True
End If

If we look at the above code, if SupChk is checked, then BudCheckbox
will *not be enabled* and vice versa for when SupChk is not checked.
Is that just a typo?

In any case, put a breakpoint in your code (in the code editor,
click once in the left magin beside the If SupChk line). Everytime you go to a new record
the code editor should come up and you'll be able to step through the code
and see what exactly is happening.

One more thing, are these checkboxes all bound?
 
Hi,

Yes all the check boxes are all bound...thanks for the
tutorial...can't tell how much I appreciate.

And it works!!!!!

Joves
-----Original Message-----
Hi,

If SupChk.Value = True Then
BudCheckbox.Enabled = False
ElseIf SupChk.Value = False Then
BudCheckbox.Enabled = True
End If

If we look at the above code, if SupChk is checked, then BudCheckbox
will *not be enabled* and vice versa for when SupChk is not checked.
Is that just a typo?

In any case, put a breakpoint in your code (in the code editor,
click once in the left magin beside the If SupChk line).
Click to expand...
Everytime you go to a new record
the code editor should come up and you'll be able to step through the code
and see what exactly is happening.

One more thing, are these checkboxes all bound?
--
HTH
Dan Artuso, Access MVP


"Joves" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top