Using Record Selectors

[Jim Franklin]

Hi,

Can anyone tell me if there is a way of manipulating the Record Selectors
for a datasheet form by using VBA code?

I have a datasheet form and would like that whenever a user clicks any field
in a particular record, the entire record is highlighted, exactly as though
the user had clicked on the record selector for that particular record. I
assumed it would be possible to do this somehow using the form's On Current
event? The data in the datasheet is read-only, so users never need to access
a particular field for editing.

Any help would be very much appreciated, thanks!

Jim F

[Jim Franklin]

Dont worry - sorted it! Thanks for reading anyway!

For anyone else with the same question, very simple really! Just use

DoCmd.RunCommand acCmdSelectRecord

in the Current Event.

Cheers,
Jim

Post by Jim Franklin
Hi,
Can anyone tell me if there is a way of manipulating the Record Selectors
for a datasheet form by using VBA code?
I have a datasheet form and would like that whenever a user clicks any
field in a particular record, the entire record is highlighted, exactly as
though the user had clicked on the record selector for that particular
record. I assumed it would be possible to do this somehow using the form's
On Current event? The data in the datasheet is read-only, so users never
need to access a particular field for editing.
Any help would be very much appreciated, thanks!
Jim F