@theDBguy, It's still not doing what I needed it to do
BUT the error is gone now
. The menu name is created so I should be able to add a record (Add A New Item) before you fixed that without the error '2427' because in the table (tbl_MenuItems) the ItemSeqNumber is 0 and not null so the DMax should see that and add +1 so the first records ( ItemSeqNumber) for that menu is 1
Thoughts?