Re: Disable checkbox

Tech-Archive recommends: Speed Up your PC by fixing your registry

since you don't say *where* you're running the code, i'm assuming that
you're running it on the Accepted checkbox's AfterUpdate event. that's
correct as far as it goes, but you also need to run the same code on the
form's Current event. that way the correct property values will be assigned
as you move from record to record in the form.

hth


"Alvin" <Alvin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D033E285-5048-4AC3-AE79-7D55A404B6BF@xxxxxxxxxxxxxxxx
> I am posting this again because I don't think it went through the first
time.
> How can I get the following code to work with each individual record in my
> subform?
> It works but it effects check boxes in all records.
> Thanks in advance
> Alvin
> ------------Start My Code---------------
> If Me.Accepted = -1 Then
> Me.Rejected.Enabled = False
> Me.Repair.Enabled = False
> Me.RepairComplete.Enabled = False
> Else
> Me.Rejected.Enabled = True
> Me.Repair.Enabled = True
> Me.RepairComplete.Enabled = True
>
> End If
> -------------End My Code--------------------


.

Relevant Pages

  • RE: Combo boxes on continuous subform
    ... but when I change the form to a continuous subform and put it on a main form, ... the references to the subform textboxes don't work. ... > This general strategy can work with any number of combo boxes. ... > ‘ AfterUpdate event of first combo box ...
    (microsoft.public.access.forms)
  • Re: updating subform via selection of combo boxes
    ... into a subform that lies on the same form as the combo boxes. ... embedded in the Subform Control are txtA, txtB, txtC, and txtD. ... the AfterUpdate event of cboC, ...
    (comp.databases.ms-access)
  • RE: Cascading Combo Boxes in Main Form
    ... place it in the AfterUpdate event of your second control. ... I have a demo of cascading combo boxes at: ... upon the selections made in Combo12 and 14. ...
    (microsoft.public.access.forms)
  • RE: Combo boxes on continuous subform
    ... "Sprinks" wrote: ... > ‘ AfterUpdate event of first combo box ... > foreign key with a DLookup function call on your lookup table: ... How could this work if I had three combo boxes? ...
    (microsoft.public.access.forms)
  • Re: Parameter Query Help
    ... Heck, I kick a lot of things off from the AfterUpdate event of text boxes, ... Doug Steele, Microsoft Access MVP ... Steve Schapel, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)