Re: Checkbox

Found it... Now, when I access the form, I get an error:

Run-Time error '94'"
Invalid use of Null

Click on Debug and it brings me to the Form_Current line with the code
highlighted. Here is my code

PrinterSerial.Visible = Me!printchk = -1
^---Is the name of textbox ^---Is the name of the checkbox
I want visable if checkbox is
checked, not if check box is
not checked

If I click on End, tehn go fourth with checking the checkbox, no error comes
up but still does what I explained earlier.
"tina" wrote:

> in design view, when you open the Properties box, make sure the Properties
> box's title bar says Form - not Section, or anything else. if it doesn't say
> Form, then double click in the gray square in the upper left corner of the
> design view window, at the junction of the vertical and horizontal rulers;
> that should change the Properties box title bar to Form. then click the
> Events tab and proceed as stated in my previous post.
>
> hth
>
>
> "Chip1035" <Chip1035@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:AFE74F0D-EDA2-4528-8CB1-3030C541CF50@xxxxxxxxxxxxxxxx
> > I cannot locate OnCurrent event procedure. I am using Access 2000, am I
> > missing something, I feel like this is suppose to be right in front of me.
> > I right click on the an emtpy area in Design View, select Properties,
> cannot
> > see a OnCurrent.
> >
> > "tina" wrote:
> >
> > > 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
    ... > If I click on End, tehn go fourth with checking the checkbox, no error ... >> box's title bar says Form - not Section, ... >> design view window, at the junction of the vertical and horizontal ...
    (microsoft.public.access.forms)
  • Re: Unchecked checkbox windows form
    ... Open your form in design view. ... Right click your dataset and View Schema. ... when a new record is added and the checkbox in unchecked. ... HTH ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Unchecked checkbox windows form
    ... Open your form in design view. ... Right click your dataset and View Schema. ... when a new record is added and the checkbox in unchecked. ... HTH ...
    (microsoft.public.dotnet.framework.adonet)
  • 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: VS2005 lost menu items
    ... design, IMHO, because hiding things you can't pretend that they exist). ... The Save Project dialoh has the textbox "Solution Name" and the checkbox ... Open Project menu actually allows you to open .sln files. ... repairing the installation ...
    (microsoft.public.vsnet.ide)