Continuous Subform Data Validation

[Fizzio]

I am having real problems validating data on a subform. All the fields on the form are required (and is set as so at table level) But I am able to enter a partial record into the continuous subform without Access trapping this. I have tried setting each individual control validation rule etc all to no avail. I have also used code courtesy of Rich (http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30669)
but I still cannot validate all the fields in the subform. Any other ideas?

Cheers

 

[doulostheou]

I have been unable to duplicate your problem. I have 3 fields set to required in a continuous subform and it will not let me go to the next record unless I have filled them out. Maybe there is something more specific going wrong that I am not understanding from your post.

 

[Rich]

Did you use the tag on the property sheet, ie. no EventProcedure just AlphaRequired on the tag line?

 

[Rich]

Oops! sorry forgot to add:
in the before update of the subform
If Not fnValidateForm(Me) Then
Cancel = True
End If

 

[Fizzio]

Thanks guys. I looked at the code again that Rich posted (Thanks Rich) and it dawned on me that my combo boxes store a number. I changed the Tag to NumberRequired and hey presto, it works!
Thanks you both for your input.

 

[Rich]

 

[Alexandre]

Definitely reached the edge of your concise style this time, Rich.
So young and already at the summit of your abilities. Hope you won't find life too boring now...

To all generous souls out there, I suggest we initiate a thread in the New board discussion forum to provide Rich with new challenges.

 

[Rich]

Well ok then but just make sure they encompass the important issues in life.
How can I improve my snowboarding/digital photography skills? How can I make a lot more money from a lot less work?
Although I'm getting more adept at the latter, lessons from a heavyweight wouldn't go amiss