Add New Record if Listbox isnull

[Taff]

Hi all,

I have a form which has a command button on it and a listbox. The problem I am having is I only want a user to be able to add a new record if:-

There are no rows in the listbox

If there are any rows in the listbox - Column(7) must not be null.

Any help is appreciated.

Thanks in advance

Anthony