sql 2012 backend linked tables
What I have:
Trying to update a Label after comparing to textbox values.
Running a dlookup in the textbox 86...but the dlookup is from a query linked into the Sql server 2012 tables.
Taking approx 3-sec to run.
If Trim(Me.Text1.Value) = Trim(Me.Text86.Value) Then
Me.Label88.Caption = "Compliant"
Me.Label88.Caption = "Not Compliant"
I have put this in many property events.
I finally had to put it in the GotFocus Event of the Texbox 86.
The query running is taking so long the comparison of the 2 textbox values are not updaqting the Label correctly.
Trying to get away from a user having to actually click in the textbox to get the correct calculation ?