Clif,

I believe it may have to do with my OnCurrent Event for the form.
I believe you're right grin.

Actually, I think I'm wrong.

It is happening with the creation of the new record on frmFacility but not
having an associated record on fsubTraining.

This doesn't happen on any of my other Form.subForm relationships so I'm not
sure what is causing it.

Any other ideas?

Here's a code snippet I use to test for an empty recordset;

Thanks for the code. I think that will come in handy for several places in
this app.

Just a comment on style (personal preference?) -- if it were my code,
I'd change lines such as

I always appreciate constructive criticism. Good advice...well taken ;-)

--
---
TraciAnn

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200907/1