I found the problem with the New button control on the form.

I had added another table to the form to populate a combobox and it was being being picked as the table to add a new record to.

Couldn't figure out why it was being picked instead since the form still had the correct table under it.

CU