Hi all,

Hoping someone can help. I've moved mu tables online and used the Microsoft SQL MSM following Richard's instructions.

So in the video it does state that it cannot allow NULL to be in the column, which is okay for a subform that I have as it has limited fields - however the main form has many fields and when something isn't completed I get the 'Drop Changes' etc comms box.

Obviously this is due to fields which are left NULL in that record, and I don't want to input a default value as not all of the fields require to be completed.

Soooo.... My question is - am I able to input a command for that field which would allow a blank entry?? i.e. looking down the Excel language I could input "" for a blank but this won't work.

If anyone could point me in the right direction with some urgency, it would be appreciated.

Many thanks

Mark