conditional formatting

[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

 

[Damon Heron]

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]

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

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

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

 

[RandyH]

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

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

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

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