Highlight (1 Viewer)

Gismo

Registered User.
Local time
Today, 09:23
Joined
Jun 12, 2017
Messages
1,298
Hi All,

I have a form with 2 sub forms
When i select a record in the first sub form by clicking on it / in focus, i want the order number to be highlighted.
then in the second sub form, all the orders with the same order number I want to be highlighted

what i did was is use conditional formatting in the second sub form when the order number is the same as the in focus on the first sub form but it is not working as hoped for
 

theDBguy

I’m here to help
Staff member
Local time
Today, 00:23
Joined
Oct 29, 2018
Messages
21,358
What does it mean by "not working?" Can you post a screenshot and the condition you used? Thanks.
 

Gismo

Registered User.
Local time
Today, 09:23
Joined
Jun 12, 2017
Messages
1,298
What does it mean by "not working?" Can you post a screenshot and the condition you used? Thanks.
it is not highlighting

1595949115288.png
 

theDBguy

I’m here to help
Staff member
Local time
Today, 00:23
Joined
Oct 29, 2018
Messages
21,358
ok just saw my mistake

fixed it

still, i need to highlight the record when I click on it in the first sub form
Have you tried using the Condition "Has Focus?"
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:23
Joined
May 7, 2009
Messages
19,169
same as this one.
 

Attachments

  • conditionalHilite.zip
    27.3 KB · Views: 117

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:23
Joined
May 7, 2009
Messages
19,169
how about if you replace Me.Recalc with Me.Refresh
 

Users who are viewing this thread

Top Bottom