Subform : Ensuring a record is entered

[Donna Tunstall]

Hi There :

Um ... I know something is wrong in my design here but can't figure out how to fix it. I have my main form and my sub form, based on tblHeader and tblDetail respectively.

For some reason, it is quite possible for a user to enter the header information on frmHeader and NOT enter a record on frmSubForm (not even be prompted). I have referential integrity set up in my relationship, which I thought would capture this but it doesn't.

Any ideas on how to stop this phenom? Any help would be appreciated. TIA.

DT

 

[Rich]

http://www.access-programmers.co.uk/ubb/Forum4/HTML/003696.html

 

[Donna Tunstall]

Thanks Rich. Thought I was doing something totally dumb that was staring me right in the face, but it would appear not (phew - sigh of relief). Of a-fixing I go.