Problem with required field on subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please help with this? I have a main form containing a subform
and the subform has a field which is required "BASED ON" one of the fields on
the main form. In other words, if MainFormFieldA = X then SubFormFieldZ is
not required. If MainFormFieldA = Y then SubFormFieldZ IS required. The
problem is that when I fill out all fields in the main form and go to the
subform to enter data, that the main form is then saved first. I need to
hold off saving either main or sub until the status of SubFormFieldZ can be
determined. Is this possible?

Thanks in advance,
 
No. You cannot create the related record in the subform until after the
primary record exists in the main form.

Additionally, the main form record must save before you move focus into the
subform.
 
Thanks for the response, Allen. Too bad about the answer though. I was
afraid that would be the case.
 
Back
Top