Discussion Locked

Access 97 Form & SubForm

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a Main Form called "Membership". ON IT, is a subform called "ALLDUE subform".

On the Main Form (Membership), each time I add a new record I want to:

1) move the focus to the Year field on "ALLDUE subform". I HAVE DONE THIS!

2) If no year is entered (on the sub form) when you try to go to a new Parent record, or save this Parent Record, a message "No Year has been entered" should pop up in a Messsage Box and cancel both the Subform changes as well as the Main Form changes.

Does anyone out there have any ideas on how to accomplish this?

Thanks,
Alan (abramowitza@coned.com)

3 replies

by john_wills

On the main form use the before insert event to do a VBA check on the contents of the subform field.

This discussion is closed to new replies.