Event when line selection changed in Datasheet view

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
 
S

Sandra Daigle

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subform selection to change detail record on mainform 2
Improving Macro That Keeps First Letter 0
arrow selector in datasheet view? 2
Problem with events not starting in datasheet view 2
select record based on record selected in the child form 4
take focus from subform 5
VBA code returns no records hwenKey ID is added 14
Controlling Columns in Datasheet View 7

Top