Action on record change from split form?

[JeffreyBH]

I have a split form -- custom form on top, datasheet on the bottom -- and
want to do two things (alter the background color of the main form Detail,
and make one of a set of images visible and the others not visible) depending
on the contents of a specific field in the selected record. My formatting
works fine as code executed when the field is changed from within the form,
but I can't find a way to change the settings when a record is selected using
the datasheet part of the split form. I thought there must be some event that
would work as a trigger, but can't seem to find one. Any ideas?

 

[Anne]

I think you need to change the form to tabular and make it look like a
datasheet.

 

[JeffreyBH]

So, basically create a tabular form and use it as a subform rather than using
the split form? I'll give that a try. Thanks!