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