Event when line selection changed in Datasheet view

  • Thread starter Thread starter Jerry Qu
  • Start date Start date
J

Jerry Qu

Hi All,

I am using datasheet view as a subform to add/update data.

1) Is there any Event when the selection changing from one line (recorde) to
another line?

2) and how to identify the current line in VB?

a subform consist of fields displayed in datasheet view, bound to

select ID, * from table

how do know the ID for the current line selected

when the selection changed, what is the Event can be used to take some
action?


TIA

Jerry
 
Hi Jerry,

The Current event fires whenever record navigation occurs.

The contents of the current record will be available through the bound
controls of the form. For example, if you have a control named CustName,
then the following will display a message containing the current name:

Msgbox "The Current Customer is: " & me.custname
 
Back
Top