Updating subform creates new record in parrent

paindivine

Registered User.
Local time
Today, 02:25
Joined
Dec 13, 2006
Messages
23
I have a form that has a main for, a subform, and then another subform inside the 1st subform. The form works like this:

Code:
Conact info
      --->Call info and notes
                          ---> Orders worked

Each of those being nested as they appear. The problem is, the user usually jumps strait to putting the order number in "Orders worked" before entering in any notes or info... So no record exists in it's parent form to tie to. How can I have the database create a new record in its parent form when the user types in the subform?

Thanks!
 
How about making the SubForms invisible or at least locked until the MainForm has been completed.
 

Users who are viewing this thread

Back
Top Bottom