Checkbox

This is what I got
Inventory Form which shows employee name, extension, computer serial number
and a checkbox for printer. When the checkbox is checked, a subform shows
the printer's serial number.

I have the following code as an AfterUpdate event
PrinterControl].Visible = Me![CheckBoxName] = -1

Now, when I view a record and the checkbox is empty, the next record has the
checkbox empty, but if I want to place a checkbox to show that employee has a
printer, the previous record has the checkbox checked with the printer
subform empty. If I uncheck the record and go back to the one that should be
checked, I find the checkbox unchecked.

It was suggested I enter the code above in the Form's current event. How
can I access the Form's current event, in order to place the code there? If
needed... If there is another code all together, bring it on so I could try
it. NOTE: I am not a pro at Access, rather just a beginner... Thank you
for any and all help, in advance...
--
-Chip
=)
.

Relevant Pages

  • Re: Checkbox
    ... the subform is based on tblPrinters - with the appropriate LinkChildFields ... note that, if an employee record has a related printer record, unchecking ... > What I want to do is have a checkbox for the printer. ... > Right now, what it is doing is, if I place a checkmark for an employee who ...
    (microsoft.public.access.forms)
  • Re: Checkbox
    ... Employee Name and their extension, computer serial number of their computer ... What I want to do is have a checkbox for the printer. ... Right now, what it is doing is, if I place a checkmark for an employee who ... > the code in the form's OnCurrent event shows or hides the subform (i am ...
    (microsoft.public.access.forms)
  • insert values into table
    ... In my UPDATE form I have a checkbox on each row. ... List of employee will appear ... Dim UpdatedRev As String ... Dim UpdateTraining As String ...
    (microsoft.public.access.formscoding)
  • Re: Checkbox question
    ... I am wanting the outcomecome to show the employees name, ... one completion for an employee, they show up as seperate records. ... Checkbox 1 - checked ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.forms)
  • Re: HELP-Fields not showing up in email
    ... Sue Mosher, Outlook MVP ... click on my checkbox, I go to Properties, then Value and it's all greyed out. ... I see where it says value in advanced properties and it has ... I created fields called, Rate, New Employee Name, ID No., Title/Dept ...
    (microsoft.public.outlook.program_forms)