[Resolved] Beginner's question

[jrpfinch]

I have a form in datasheet view and am trying to write some VB to go with it. Two questions:

1) Is there a property for which record the cursor is sitting in that I can refer to in the code?

2) Can I write code such that when I click on a record it highlights the whole line (as if I had clicked on the grey square to the left of it)

Thanks v much for your help

[RobDog888]

I take it that you are using Access. For the first question, I think
the event is "Private Sub Form_Current()". Not too sure because
I know it works for a form in Form view. So for Datasheet view ?
For the second question I dont think so.

[jrpfinch]

Sorry I think I must have phrased the question wrongly

1) How can I identify which record the cursor is in on a form which has a datasheet in it? (I'm guessing it's something like frmMain.ActiveRecord or similar)

[RobDog888]

Me.CurrentRecord

Will give you the record that the user has the cursor in. If you
click on a record you will see the data control change its position.
For example if you have 50 records total and you click on the 25th
record then the data control change to say "25 of 50 Records".
So thats why I thought that the Current event would give you
the info. These properties also should help you get what you
want.

Me.CurrentRecord
Me.CurrentSectionLeft
Me.CurrentSectionTop

[jrpfinch]

Thanks that's perfect