Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional formating between two forms 1

Status
Not open for further replies.

DevelopV

Technical User
Mar 16, 2012
113
ZA
I have a form "frmCustomerPaymentFindInvoiceOrder" with an unbound subform "frmCustomerPaymentFindInvoice"
There are no linked master / child fields

In the main form is a combo box "cboCustomer" that shows a list of customers. The first column of the combo box is the CustomerId
The data source for the subform also contains the CustomerId and the criteria for this field is [Forms]![frmCustomerPaymentFindInvoiceOrder]![cboCustomer]

In the main form is an unbound control called "PaymentValue"

In the sub form is a control called "InvoiceValue"

I wish to apply conditional formatting to the control "InvoiceValue", so if "InvoiceValue" = "PaymentValue" then the background colour of "InvoiceValue" is red

I have opened "frmCustomerPaymentFindInvoice" in Layout View, and selected Conditional formatting. Selected field "InvoiceValue" and set the condition to "Field Value Is Equal to Forms![frmCustomerPaymentFindInvoiceOrder]![PaymentValue].
I have also selected a background colour.

However the conditional formatting does not work!

Any suggestions on how to fix this?
 
Expression is"
Forms!frmCustomerPaymentFindInvoiceOrder.cboCustomer = [invoiceValue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top