Here is the expression:
Expand|Select|Wrap|Line Numbers
- DCount("ClientName","Clients","ClientName=[SuggestedClientName]")-1.
One way to handle this discrepancy is for the user to pull up the Clients form and add the new ClientName value. After adding the SuggestedClientName to the Clients table, the user returns to the SalesLead form. I want the conditional formatting to re-evaluate the SuggestedClientName text box in the form when the focus is returned to the SalesLead form.
This is where my problem lies.
No matter what I try, I have to close the form and re-open it to re-evaluate the conditional formtting. I tried adding the following VBA code to the form's On Got Focus event.
Expand|Select|Wrap|Line Numbers
- Private Sub Form_GotFocus()
- Forms![SalesLead].[SuggestedClientName].Refresh
- End Sub
Do I have the wrong event? Do I have the wrong code? Does the disabled and/or locked settings have anything to do with my problems?
HELP!!!