dbclick checking

[Souris]

I have a double click event on the datasheet form.

It is fired all the time. I would like to triglle the event only there is
data on it.
Are there any property to check for record exists before execute the code?

your help is great appreciated,

 

[Bob Cutler]

Use the NewRecord property to check if the doubleclick was on the blank row
at the bottom. Use ISNULL() to check if a specific field is empty.

 

[Klatuu]

You can't stop the event from firing, but you can cause it not to do anything
if the object you double click on is null:

If Not IsNull(Me.SomeControl) Then
'do things
End If