Would like to use mouse click to specify a record.

[THOMASNG]

I'm using VB Professional 6.0 and Access 2000. With
much help, I've got the Access 2000 database (on my desktop)
to work with VB6 and the ADO DC (on my mobile PC).
To ease changing the Access 2000 database, I'd like a
simple mouse-based technique, to select the record I'd
like to see/modify/add/delete the data the data for.
Currently, all data modifications will ONLY take place for
that record which is at the top row of the datagrid.

 

[THOMASNG]

I would prefer not to use the EDIT|Go TO|Next procedure,
because it could take many iterations if there are several
hundred records.

 

[THOMASNG]

I can already get the AbsolutePosition of a record by
clicking on it with my mouse. I'd just like to go a bit further and use it to access each field.