Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    subform question

    Need to know if this is possible.. I have a form that has an attached sub form.. Is it possible that if the user enters data in a field on the main form that the it would then require them to enter data in the fields of the attached subform before the can go to a new record.. Thanks for the help..

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: subform question

    Is there a reason why you couldn't have all of the fields on the main form?

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: subform question

    You should be able to use the before update event to verify that all required fields have been entered before the records are updated. Your code could then alert the user and allow him to cancel the entire update or go back to the form to enter the remaining info.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •