Force data entry of Main form AND sub form

[zmbd]

I have a few family obligations here; however, once I get those done I'll bash something togeither for you to look at...

[zmbd]

here's a fish

here's a fish...

ACC2010 format

ON open the parent form should open.

THe three buttons at the top for record movement are not foolproof, yet they work fairly well and the add new will take you to the new record entry.

Here's what happens, current record, it calls the buttons and the buttons call the code too.
UPon new, the focus shifts to the first name.
Now if the user dirties the controls (these are bound) then the before update event triggers. IF they select yes then the parent record is saved, the child record created and the focus is set on a control within the subform.

I've tried it several times and it appears to work, has a few more bells and whistles than I had intended...
good night.... time for somzzzzzzzzzzzz zzzzzzzzzzzzzzz zzzzzzzzzzzz

[RockKandee]

Hope you had sweet dreams. Thank you! I am in process of dissecting my fish now. You're the best.