Highlight (1 Viewer)

Gismo

Registered User.
Local time
Today, 19:59
Joined
Jun 12, 2017
Messages
548
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, 09:59
Joined
Oct 29, 2018
Messages
11,114
What does it mean by "not working?" Can you post a screenshot and the condition you used? Thanks.
 

Gismo

Registered User.
Local time
Today, 19:59
Joined
Jun 12, 2017
Messages
548
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, 09:59
Joined
Oct 29, 2018
Messages
11,114
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

error reading drive A:
Local time
Tomorrow, 00:59
Joined
May 7, 2009
Messages
9,872
how about if you replace Me.Recalc with Me.Refresh
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom