Pat... you are so awesome... I really appreciate your answer to my questions at http://www.access-programmers.co.uk/forums/showthread.php?threadid=29917&goto=newpost
I need to clarify something though... The tables for my form, subform, sub-subform do have relationships designed in the database structure. I do understand your explination but I was not really clear in my original post about my form-subform with my Calls and their Notes. All Calls and their Notes are in one table, there is only one note field per call record (it is a Memo). So, what I really have is a form with 6 fields from Calls in a Datasheet layout and the subform is the Notes field in a single form view.
Does this make a difference from your original response? Since the record in Call is the same record in Note? The user would like to be able to enter the date of the call (in the calls form) then go directly to the Notes to get all the detail, then go back to the call to fill in the rest of the required fields. Unfortunatly, when they try to move to the Notes subform they are prompted for fill in all the required fields in calls. I am checking on before update for all required field and can only check the ones on the Call form not the Notes subform (both based on the Calls recordset).
Again, I really appreciate your origninal response and hope you can take the time to clarify this for me with the additional info I have provided... thanks so much
I need to clarify something though... The tables for my form, subform, sub-subform do have relationships designed in the database structure. I do understand your explination but I was not really clear in my original post about my form-subform with my Calls and their Notes. All Calls and their Notes are in one table, there is only one note field per call record (it is a Memo). So, what I really have is a form with 6 fields from Calls in a Datasheet layout and the subform is the Notes field in a single form view.
Does this make a difference from your original response? Since the record in Call is the same record in Note? The user would like to be able to enter the date of the call (in the calls form) then go directly to the Notes to get all the detail, then go back to the call to fill in the rest of the required fields. Unfortunatly, when they try to move to the Notes subform they are prompted for fill in all the required fields in calls. I am checking on before update for all required field and can only check the ones on the Call form not the Notes subform (both based on the Calls recordset).
Again, I really appreciate your origninal response and hope you can take the time to clarify this for me with the additional info I have provided... thanks so much
