Re: Checkbox

in the table underlying the form, you should have a field to store the
Yes/No value re printer availability. make sure that field is included in
the form's RecordSource. bind the checkbox control to the Yes/No field (set
the checkbox control's ControlSource to the name of the field). then include
your code in the form's OnCurrent event procedure, and in the checkbox
control's AfterUpdate event procedure. to add the code:

1. open the form in design view.
2. open the Properties box (if it's not already open), click on the Events
tab, and then double click in the white space at the right of the On Current
event (first event listed). Access will create the event procedure and open
the VBA Editor window, with the cursor inside the procedure.
3. enter your line of code, as

Private Sub Form_Current()

PrinterControl.Visible = (Me!CheckBoxName = -1)

End Sub

4. go back to form design view.
5. click on the checkbox control to select it.
6. in the Properties box, again double click on the AfterUpdate event line.
7. enter your code inside the procedure, same as before.

hth


"Chip1035" <Chip1035@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0594D03D-2A50-43DD-971F-85BF54CB86C5@xxxxxxxxxxxxxxxx
> 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
    ... I cannot locate OnCurrent event procedure. ... > the checkbox control's ControlSource to the name of the field). ... >> Now, when I view a record and the checkbox is empty, the next record has ...
    (microsoft.public.access.forms)
  • Re: Editable field only based on another field
    ... you will need to create an AfterUpdate event procedure ... in the After Update under properties of my checkbox control, ... an error saying the the Macro doesn't exist. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Checkbox
    ... in design view, when you open the Properties box, make sure the Properties ... box's title bar says Form - not Section, ... >> the checkbox control's ControlSource to the name of the field). ... >> your code in the form's OnCurrent event procedure, ...
    (microsoft.public.access.forms)
  • Re: Disabling checkboxes when an "approved" checkbox is checked
    ... Then code the AfterUpdate event of the first check box: ... my code for the "approved" checkbox AfterUpdate event is: ... Sounds like you are confusing the Current event procedure ... If you select in the OnCurrent property, ...
    (microsoft.public.access.formscoding)
  • Re: Show fields on one record not on others?
    ... Thanks for your help on this Marshall, I must be missing some other piece of the puzzle because this idea didn't work in my case. ... I included the line in the checkbox afterupdate event, as well, but still no luck. ... Some "sales" are in California and then I want to display a field "CA tax". ...
    (microsoft.public.access.formscoding)