Moving auto Number to a field on a different table?

[d9pierce1]

Hi June,
I get it when I type in a new name, then It asks me if I want to add, If I say yes, then it comes up. So I guess once the NIL fires, then this if yes is selected

[June7]

Type a new name in unbound combobox on frmOnLineAccess and reply yes to add? Nope, no message.

[d9pierce1]

Hi June,
Did you try my new test copy? I tried it with desktop, laptop, win10,win11 and I get this error on both?
I dont have any validation rules so not sure why?
Thanks

[d9pierce1]

Hi June,
Thank you for all the assistance with this. I finally figured out how to get rid of that validation rule message!
I put in Me.TxtWebsite.SetFocus after the requery in the code and the message went away!
Will marked solved
Again, thank you
Dave

[Welshgasman]

I think it was being generated when the subform combo received the focus after adding a new entry in the mainform combo.

[June7]

Yes, I tried with your db from post 14.