RE: Make text box control source change based on a check box selection

Allow me to clarify: The two check boxes are a part of an option group
(Frame 155), and the value for Margin is 1, and the value for Markup is 2.
Basically, if the value is 2, I need the control source of Text354 to be my
formula...thanks again.

KARL DEWEY wrote:
>Check boxes have three states - Null (gray), Yes (checked), and No (white).
>When the form is opened they are gray unless you have an event/macro to set
>them.
>In your case I would suggest using an Option Group as your check boxes could
>both be the same.
>
>> Hello, I am trying to set up a form in a user has to select one of 2 check
>> boxes: Margin (Check 158) or Markup (Check 160). Then the user will tab
>[quoted text clipped - 13 lines]
>> Can anyone help? Sorry for all the meaningless control names, and thanks in
>> advance for your help.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200512/1
.

Relevant Pages

  • Using on-the-fly in a report?
    ... Hi I have 2 txt boxes in my form that do calcualtions using the control ... For example the txt box margin has a control source of netcost-jobcost (which ... calculation that was made in the form. ...
    (microsoft.public.access.forms)
  • Re: Option Group results on reports
    ... You have a Yes/No field in a table, and you are using an option group to interface it. ... Now you want to show this yes/no field on a report in 2 columns. ... To create the other column, add another check box, and set its Control Source to: ... but don't know how to get their choice into the two boxes. ...
    (microsoft.public.access.reports)
  • Re: Using on-the-fly in a report?
    ... For example the txt box margin has a control source of netcost-jobcost ... As the two txt boxes results are not stored in a table can someone please ... Not every report has both netcost ...
    (microsoft.public.access.forms)
  • Re: Make text box control source change based on a check box selection
    ... strFormula = ... The two check boxes are a part of an option group ... > Basically, if the value is 2, I need the control source of Text354 to be ...
    (microsoft.public.access.forms)
  • Re: One check box or the other
    ... already going to be an option group it may as well be the bound control. ... First, you would need the two check boxes bound to the two controls, ... When a vendor's certificate is due to expire we request an updated ...
    (microsoft.public.access.formscoding)
Loading