Conditional Formatting like in Excel

[lmcc007]

Is there a way to do Conditional Formatting like in Excel? Meaning, if [Warranty] = TRUE, go to the [DaysofWarranty] field. But, if [Warranty] = FALSE, skip to the [Charity] field.

 

[CameronM]

Is the Warranty field a text, checkbox or combobox control? As this will change how to access the value and events.

If [Warranty] is a checkbox or combobox on your form, you can use the After_Update event to test the condition you want.

I have prefixed the fields with the control type I assumed they represent.

    If cboWarranty = -1 Then
        txtDaysofWarranty.SetFocus
    Else
        txtCharity.SetFocus
    End If

 

[lmcc007]

Thanks CameronM, it's working great!