My ignorance...

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

Guest

Hi!

I have a Form1 and Form2 based to be just in same conditional query.
In the Form1 there are one cboPlans to choose one plan.
When we click in cboPlans to choose it, open the Form2.

In accordance with choosed plan, the Form2 show us one or more pairs: One
Textbox (Enable=No and Locked=Yes, with action to execution) and one Checkbox
(to confirmation of action).

I would like when clicking in Checkbox:
1 – Change only the Checkbox to Visible = False;
2 – Change Textbox colour, type Enable=No and Locked=No, to accentuate
executed action or not.

Thanks in advance.
an
 
An,

This is an unusual thing to do, in my experience. You mean when you
tick the checkbox it will no longer be visible? Than means you will not
be able to reverse the action... is that what you want?

In any case, if Form2 is a continuous view form, which is sounds like it
is, you will not be able to use code to get the functionality you want.
Hiding the checkbox will make it invisible for all records.

Changing the colour of the textbox is simpler. You can use conditional
formatting. Select the textbox in design view of the form, and then
select Conditional Formatting from the Format menu. Enter the
Expression Is... as the euivalent of...
[NameOfCheckbox]=-1
.... and set the colour accordingly.
 
Thanks for your reply.

1 - In fact...
2 - Work fine.

Thanks more one time, for your help
an

Steve Schapel said:
An,

This is an unusual thing to do, in my experience. You mean when you
tick the checkbox it will no longer be visible? Than means you will not
be able to reverse the action... is that what you want?

In any case, if Form2 is a continuous view form, which is sounds like it
is, you will not be able to use code to get the functionality you want.
Hiding the checkbox will make it invisible for all records.

Changing the colour of the textbox is simpler. You can use conditional
formatting. Select the textbox in design view of the form, and then
select Conditional Formatting from the Format menu. Enter the
Expression Is... as the euivalent of...
[NameOfCheckbox]=-1
.... and set the colour accordingly.

--
Steve Schapel, Microsoft Access MVP
Hi!

I have a Form1 and Form2 based to be just in same conditional query.
In the Form1 there are one cboPlans to choose one plan.
When we click in cboPlans to choose it, open the Form2.

In accordance with choosed plan, the Form2 show us one or more pairs: One
Textbox (Enable=No and Locked=Yes, with action to execution) and one Checkbox
(to confirmation of action).

I would like when clicking in Checkbox:
1 – Change only the Checkbox to Visible = False;
2 – Change Textbox colour, type Enable=No and Locked=No, to accentuate
executed action or not.

Thanks in advance.
an
Click to expand...
Click to expand...
 
Back
Top