Check Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a check box in a form. If the check box is checked it will auto fill
information in a text box under the check box with the same information that
was filled in from another text box. If the check box isn't checked I want to
be able to fill in information in that text box. It will not allow me to fill
in information when the check box isn’t checked. How would I code it so I can
do that?

This is my current coding:

=IIf([Libor Contact]=True,[customer Contact primary],IIf([libor
Contact]=False,[customer contact]))
 
Is the "coding" that you provided the ControlSource of the textbox? If yes,
you will not be able to edit any information in that textbox because its
value is controlled by that expression.

If you want the combination of options, then the ControlSource of the
textbox must be empty. Instead, you would need to use code to put the value
into that textbox when the checkbox is checked.

In looking at this expression, it will put a value into the textbox for
either value of the checkbox. So is it that you want to be able to edit what
is put in the textbox by the expression?

Let me know if I'm off track .... post back with more info so that we can
identify where the code would need to be put.
 
Ken,

Yes it's a Control Source of the text box. I want to be able to take a value
that was entered from a different Control Source if the box is check
otherwise I would like to manually put a different name in that Contral
Source. I hope I'm making sense. Thanks in Advance

Ken Snell said:
Is the "coding" that you provided the ControlSource of the textbox? If yes,
you will not be able to edit any information in that textbox because its
value is controlled by that expression.

If you want the combination of options, then the ControlSource of the
textbox must be empty. Instead, you would need to use code to put the value
into that textbox when the checkbox is checked.

In looking at this expression, it will put a value into the textbox for
either value of the checkbox. So is it that you want to be able to edit what
is put in the textbox by the expression?

Let me know if I'm off track .... post back with more info so that we can
identify where the code would need to be put.

--

Ken Snell
<MS ACCESS MVP>


Penny said:
I have a check box in a form. If the check box is checked it will auto fill
information in a text box under the check box with the same information
that
was filled in from another text box. If the check box isn't checked I want
to
be able to fill in information in that text box. It will not allow me to
fill
in information when the check box isn't checked. How would I code it so I
can
do that?

This is my current coding:

=IIf([Libor Contact]=True,[customer Contact primary],IIf([libor
Contact]=False,[customer contact]))
Click to expand...
Click to expand...
 
OK -

Do you want this to happen during the creation of a new record? Assuming
yes, move the expression from the textbox's Control Source to the textbox's
Default Value.

--

Ken Snell
<MS ACCESS MVP>


Penny said:
Ken,

Yes it's a Control Source of the text box. I want to be able to take a
value
that was entered from a different Control Source if the box is check
otherwise I would like to manually put a different name in that Contral
Source. I hope I'm making sense. Thanks in Advance

Ken Snell said:
Is the "coding" that you provided the ControlSource of the textbox? If
yes,
you will not be able to edit any information in that textbox because its
value is controlled by that expression.

If you want the combination of options, then the ControlSource of the
textbox must be empty. Instead, you would need to use code to put the
value
into that textbox when the checkbox is checked.

In looking at this expression, it will put a value into the textbox for
either value of the checkbox. So is it that you want to be able to edit
what
is put in the textbox by the expression?

Let me know if I'm off track .... post back with more info so that we can
identify where the code would need to be put.

--

Ken Snell
<MS ACCESS MVP>


Penny said:
I have a check box in a form. If the check box is checked it will auto
fill
information in a text box under the check box with the same information
that
was filled in from another text box. If the check box isn't checked I
want
to
be able to fill in information in that text box. It will not allow me
to
fill
in information when the check box isn't checked. How would I code it so
I
can
do that?

This is my current coding:

=IIf([Libor Contact]=True,[customer Contact primary],IIf([libor
Contact]=False,[customer contact]))
Click to expand...
Click to expand...
Click to expand...
 
This didn't work. Any other suggestions?

Ken Snell said:
OK -

Do you want this to happen during the creation of a new record? Assuming
yes, move the expression from the textbox's Control Source to the textbox's
Default Value.

--

Ken Snell
<MS ACCESS MVP>


Penny said:
Ken,

Yes it's a Control Source of the text box. I want to be able to take a
value
that was entered from a different Control Source if the box is check
otherwise I would like to manually put a different name in that Contral
Source. I hope I'm making sense. Thanks in Advance

Ken Snell said:
Is the "coding" that you provided the ControlSource of the textbox? If
yes,
you will not be able to edit any information in that textbox because its
value is controlled by that expression.

If you want the combination of options, then the ControlSource of the
textbox must be empty. Instead, you would need to use code to put the
value
into that textbox when the checkbox is checked.

In looking at this expression, it will put a value into the textbox for
either value of the checkbox. So is it that you want to be able to edit
what
is put in the textbox by the expression?

Let me know if I'm off track .... post back with more info so that we can
identify where the code would need to be put.

--

Ken Snell
<MS ACCESS MVP>


I have a check box in a form. If the check box is checked it will auto
fill
information in a text box under the check box with the same information
that
was filled in from another text box. If the check box isn't checked I
want
to
be able to fill in information in that text box. It will not allow me
to
fill
in information when the check box isn't checked. How would I code it so
I
can
do that?

This is my current coding:

=IIf([Libor Contact]=True,[customer Contact primary],IIf([libor
Contact]=False,[customer contact]))
Click to expand...
Click to expand...
Click to expand...
 
Back
Top