Invisible Check Boxes

[jdph40]

Is there any way to do this on a form in Access 97? If the value of a
combo box is .5, I want two check boxes to be visible (labels are a.m
and p.m.). If the value of the combo box is 1, I want the two check
boxes to be invisible.

Thanks,
JD

[Fredg]

In the Combo Box's AfterUpdate event AND in the form's Current event:

CheckAM.Visible = ComboBox = .5
CheckPM.Visible = ComboBox = .5

The above assumes the Combo Box value shown is the combo's Bound column.

If it is not the bound column then use
=ComboBox.Column(x)
where x is the column shown - 1.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
<jd****@yahoo.com> wrote in message
news:75**************************@posting.google.c om...

Is there any way to do this on a form in Access 97? If the value of a
combo box is .5, I want two check boxes to be visible (labels are a.m
and p.m.). If the value of the combo box is 1, I want the two check
boxes to be invisible.

Thanks,
JD

[Arno R]

Use this in The Forms OnCurrent event:
Me!ChkBox1.visible = Not Me!ComboBox=1
Me!ChkBox2.visible = Not Me!ComboBox=1

(Replace the names of the Checkboxes and the Combobox)
--
Hope this helps
Arno R

<jd****@yahoo.com> schreef in bericht news:75**************************@posting.google.c om...

Is there any way to do this on a form in Access 97? If the value of a
combo box is .5, I want two check boxes to be visible (labels are a.m
and p.m.). If the value of the combo box is 1, I want the two check
boxes to be invisible.

Thanks,
JD

[jdph40]

Thanks, Fred. One more question...I'm using this in a subform, and
when the value of the combo box in one record is .5 and the check box
is visible for that record, it is also visible for all other records
in the subform, even if the value of the combo box is 1. Is there any
way to make this record-specific and not form-specific?

Thanks,
JD

"Fredg" <fg******@att.net> wrote in message news:<lj**********************@bgtnsc05-news.ops.worldnet.att.net>...

In the Combo Box's AfterUpdate event AND in the form's Current event:

CheckAM.Visible = ComboBox = .5
CheckPM.Visible = ComboBox = .5

The above assumes the Combo Box value shown is the combo's Bound column.

If it is not the bound column then use
=ComboBox.Column(x)
where x is the column shown - 1.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
<jd****@yahoo.com> wrote in message
news:75**************************@posting.google.c om...

Is there any way to do this on a form in Access 97? If the value of a
combo box is .5, I want two check boxes to be visible (labels are a.m
and p.m.). If the value of the combo box is 1, I want the two check
boxes to be invisible.

Thanks,
JD

[Jim]

Select Combo box's after update event, enter:
if comboName = 0.5 then
Check1Name.visible = false
Check2Name.visible = false
Else
Check1Name.visible = true
Check2Name.visible = true
End if

If you have 3rd possibility, you should use SELECT CASE statement.

jd****@yahoo.com (jd****@yahoo.com) wrote in message news:<75**************************@posting.google. com>...

Is there any way to do this on a form in Access 97? If the value of a
combo box is .5, I want two check boxes to be visible (labels are a.m
and p.m.). If the value of the combo box is 1, I want the two check
boxes to be invisible.

Thanks,
JD

[Bruce M. Thompson]

> Thanks, Fred. One more question...I'm using this in a subform, and

when the value of the combo box in one record is .5 and the check box
is visible for that record, it is also visible for all other records
in the subform, even if the value of the combo box is 1. Is there any
way to make this record-specific and not form-specific?

No. In a continuous form, if a control is visible in one record, it is visible
in all records. Using your code in the "On Current" event procedure, you can
control the visibility of the controls as you move from record to record but,
again, this affects every instance of the controls.

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<