conditional formatting

  • Thread starter Thread starter RandyH
  • Start date Start date
R

RandyH

TIA

I have a form (frmCustomer) which has a checkbox (chkInactive). The
fields on the form have conditional formatting applied in such a way that
they become disabled (not editable) and grayed out when the checkbox is
checked. Now, I would like to set conditional formatting on a different form
(frmWorkOrders) that will become disabled and grayed out when the checkbox
is checked from frmCustomer.
My current conditional expression is [chkInactive]=True, how would I
change this on frmWorkOrders to work?

Randy
 
Randy,
I suppose your WorkOrders table has a foreign key for customers and they are
related one to many...
On the WorkOrder form, use a combobox to display the customers. For the
rowsource, use

SELECT tblCustomer.CusID, tblCustomer.CusName, tblCustomer.chkInactive
FROM tblCustomer
WHERE (((tblCustomer.chkInactive)=No));

This will only show the Active customers for the workorder form. Therefore,
no need to grey out anything on the Work form.

HTH
Damon
 
Thanks Damon for the response, but...I have unbound text box's on my
WorkOrder form which displays the customerID, primary contact, phone number
and city/state. I do need ALL of the customers to show up in the WorkOrder
form, this way when talking to that customer we will know they have been
inactive but will still be able to log that call.

Randy

Damon Heron said:
Randy,
I suppose your WorkOrders table has a foreign key for customers and they are
related one to many...
On the WorkOrder form, use a combobox to display the customers. For the
rowsource, use

SELECT tblCustomer.CusID, tblCustomer.CusName, tblCustomer.chkInactive
FROM tblCustomer
WHERE (((tblCustomer.chkInactive)=No));

This will only show the Active customers for the workorder form. Therefore,
no need to grey out anything on the Work form.

HTH
Damon

RandyH said:
TIA

I have a form (frmCustomer) which has a checkbox (chkInactive). The
fields on the form have conditional formatting applied in such a way that
they become disabled (not editable) and grayed out when the checkbox is
checked. Now, I would like to set conditional formatting on a different form
(frmWorkOrders) that will become disabled and grayed out when the checkbox
is checked from frmCustomer.
My current conditional expression is [chkInactive]=True, how would I
change this on frmWorkOrders to work?

Randy
Click to expand...
Click to expand...
 
Incase anyone is interested, I solved this problem by adding the checkbox
(chkInactive) to my WorkOrder form, then changed the 'visible parameter to
no (hides the checkbox). Then I applied conditional formatting to the fields
in question.

Randy


RandyH said:
Thanks Damon for the response, but...I have unbound text box's on my
WorkOrder form which displays the customerID, primary contact, phone number
and city/state. I do need ALL of the customers to show up in the WorkOrder
form, this way when talking to that customer we will know they have been
inactive but will still be able to log that call.

Randy

Damon Heron said:
Randy,
I suppose your WorkOrders table has a foreign key for customers and they are
related one to many...
On the WorkOrder form, use a combobox to display the customers. For the
rowsource, use

SELECT tblCustomer.CusID, tblCustomer.CusName, tblCustomer.chkInactive
FROM tblCustomer
WHERE (((tblCustomer.chkInactive)=No));

This will only show the Active customers for the workorder form. Therefore,
no need to grey out anything on the Work form.

HTH
Damon

RandyH said:
TIA

I have a form (frmCustomer) which has a checkbox (chkInactive). The
fields on the form have conditional formatting applied in such a way that
they become disabled (not editable) and grayed out when the checkbox is
checked. Now, I would like to set conditional formatting on a
Click to expand...
different
form
(frmWorkOrders) that will become disabled and grayed out when the checkbox
is checked from frmCustomer.
My current conditional expression is [chkInactive]=True, how would I
change this on frmWorkOrders to work?

Randy
Click to expand...
Click to expand...
Click to expand...
 
Back
Top