dbclick checking

  • Thread starter Thread starter Souris
  • Start date Start date
S

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,
 
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.
 
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
 
Back
Top