J
John
I've received a variety of answers on this and I want to thank everyone for their input. The answers however don't resolve my issues. I think I made the whole issue too complex so I'm going to try this. Please bare with me
Main form PrspDemoInformation - Houses all the personal information address name etc
Tab Control Tab_Academic - Houses the subform_ProspectInformation
subfrm_ProspectInformation - Houses all the educational information
Problem: If entry is made in the main form and no entry is made in the PrspInfoHSAttend field in the sub form that the record not be saved and the user be directed to go to that tab and indicate high school information i.e. field can not be null
I know I need an sql statement in the afterupdate on the main form. I've tried various statements and non have worked. I know the answer is out there. This is my last issue I have with this thing. It's like winning the lottery and then waking up to find out it was only a dream. All the answers have been close but non have quite made it. I do appreciate everyone's input though. Some of the suggestions will be really useful in other database. Unfortunately I didn't design this one but I rather had to fix a number of issues. Like I said though this one just keeps on escaping me. Someone please help before I pull out all my hair
Main form PrspDemoInformation - Houses all the personal information address name etc
Tab Control Tab_Academic - Houses the subform_ProspectInformation
subfrm_ProspectInformation - Houses all the educational information
Problem: If entry is made in the main form and no entry is made in the PrspInfoHSAttend field in the sub form that the record not be saved and the user be directed to go to that tab and indicate high school information i.e. field can not be null
I know I need an sql statement in the afterupdate on the main form. I've tried various statements and non have worked. I know the answer is out there. This is my last issue I have with this thing. It's like winning the lottery and then waking up to find out it was only a dream. All the answers have been close but non have quite made it. I do appreciate everyone's input though. Some of the suggestions will be really useful in other database. Unfortunately I didn't design this one but I rather had to fix a number of issues. Like I said though this one just keeps on escaping me. Someone please help before I pull out all my hair