Identifying Which Record Is Selected In A Subform

[zucke...@gmail.com]

Hello All,

Access 2007.
Unbound main form with 2 subforms.
Both subforms are in datasheet view.
The 2nd subform is master/child linked to the 1st subform.

Everything works fine, except:
When a users selects a record in the 2nd subform, it is very difficult
to tell which record is highlighted in the 1st subform. There does
seem to be a slight color variation but it is VERY subtle. I seem to
recall that A2K would display a black triangle in the record selection
column, but A2007 does not. A2007 seems to highlight the selected
record in color, but that disappears (or goes very subtle) when focus
is lost.

How do you all handle this?
Thanks,
Fred

[Banana]

The black triangle you spoke of -- this is a part of a feature named
"Record Selector" and it's still in A2007. However, it can be optionally
enabled or disabled - it's a property of the form so you need to check
if the subform's form object has its Record Selector set to "No" and set
it back to "Yes"

[zucke...@gmail.com]

On Apr 13, 7:12 pm, Banana <Ban...@Republic.com> wrote:

> it back to "Yes"- Hide quoted text -
>
> - Show quoted text -

Thank you, Banana.
I've double checked the property setting on the parent form and both
child forms. They all have the Record Selector property set to YES.
But I still do not see the black triangle on the selected record of
the subfrom. I'm using A2007.
Fred

[zucke...@gmail.com]

On Apr 15, 10:40 pm, "zuckerm...@gmail.com" <zuckerm...@gmail.com>
wrote:

> Fred- Hide quoted text -

>
> - Show quoted text -

At home I have A2k (not A2007). The subforms display as I intended on
my home computer. I varied the form property called Record Selector
back & forth between Yes & No and it seemed to make no difference. I
checked the help file and it says the Record Selector property applies
ONLY to single form view (not datasheet view).

So my problem is still puzzling to me. In A2007 the record selector
(black triangle) in datasheet view is not visible????? Do any other
A2007 users confirm this?
I wonder if it has something to do with some Windows OS color scheme
in the system setting.
Thanks,
Fred

[zucke...@gmail.com]

On Apr 15, 11:17 pm, "zuckerm...@gmail.com" <zuckerm...@gmail.com>

Well, I have more details.
I changed the view of my subforms from datasheet to continuous forms
and the black triangles display as intended. I don't know why they
don't display in datasheet view as they did in A2k. Maybe it's a bug
in A2007, or maybe it was a long-standing bug in A2000. Oh well. I
usually prefer datasheet view over continuous forms. Even though I can
make continuous forms look like a datasheet, the keyboard cursor keys
operate differently for navigation.
Fred

[Kathy Whitehead]

This is definitely a data sheet issue. I have the same problem myself
but prefer to keep using datasheets so that my users have some control
over their views in that they can hide columns, adjust column widths and
re-order columns. Worse than no record selectors is the highlight of
the selected row issue. The colouration is so discrete that it is
virtually impossible to tell which row is selected - especially if one
moves from the data sheet to another subform embedded in the main form.
Any one have any ideas?

*** Sent via Developersdex http://www.developersdex.com ***