Still Stuck.
I added SQL Server default values for all my NOT NULL fields and have a further discovery to report.
It seems like the failure relates to two records being created when I use the NewVisitorTypeUltraButtonNew OR this record is being saved (without any values) before the navigation to a second new record.

Perhaps by strategy of calling the both a save on the current datarow and dataset prior to navigation via my navigation buttons may be part of the problem.

        Me.oVisitorType.SaveRow()
        Me.oVisitorType.SaveDataSet()

Any thoughts on what I am doing wrong are truely welcomed!
By the way thanks Eugenio for the insights that at least have led me down a different path.