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
Sandra Daigle - 03 Jan 2005 16:40 GMT
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

Signature
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.
> Hi All,
>
[quoted text clipped - 17 lines]
>
> Jerry