How to delete an entire line from a table using a delete query

[JeffreyDavid]

I have a form and subform, if the form is opened and closed without doing anything, it creates a blank line in the table. Given enough time, that table will be a mess. I want to create a delete query based on,
If Product is Null
If Model is Null
If Description is Null
If Type is null
I want to delete the entire line if those fields are null.
How would one go about acomplishing this?

 

[RichO]

How about :

DELETE * FROM MyTable WHERE
Nz([Product] & [Model] & [Description] & [Type]) = ""

However, there should be a way to prevent a blank record from being inserted in the first place. Perhaps one of the experts here can help you figure that out.

 

[pono1]

A common technique is to place validation code in the form's Before Update Event...

If Isnull(me.ThisTextbox) or thisTextBox = "" Then
	Cancel = True 'Don't save the record.
             Msgbox "Please fill out..."
End if

Regards,
Tim